Settings in Excel 2013 2010 2007 2003

Creating a Drop-Down List in a Cell

Manual data entry into spreadsheets and especially entering data into text cells leads to many errors. Excel data validation tools allow you to reduce the inaccuracy of Excel data entry by restricting the set of possible values to a pre-defined list. Users can select the item from a drop-down list with few choices, instead of typing text into the data entry form template.

How to reduce ribbon size in Excel

After recent updates, the ribbon in Microsoft Excel can take up to 1/3 of the available screen space. Microsoft Office help tells that you can hide or unhide your ribbon, but you cannot reduce the size of your ribbon, or size of the text or the icons. False! You can change the mode and remove unnecessary white space around buttons, and, thus, reduce the ribbon size.

Conditional formatting for weekends

When you create a data table with daily records, you can need to highlight weekends or other specific days. You don’t need to open a Calendar and do it manually, Excel proposes conditional formatting that can help you do it without any calculation.

How to use Camera tool in Excel

When you work with some Excel elements such as tables, charts, you spend a lot of time on positioning them and formatting. Here will find the feature that Excel proposes to help you create a perfect presentation of your data.

How to remove all hyperlinks in your Excel spreadsheet

By default, Excel automatically creates hyperlinks when you type or insert URLs or e-mails. You can Turn off the automatic creation of hyperlinks in Excel, or delete all hyperlinks later.

How to show image linked to the list element

Microsoft Excel proposes a lot of different features for creating a perfect presentation of your data. One of these features is linked elements. This tip shows how to create a drop-down list and automatically show linked objects, such as image, text, hyperlink, etc. for the selected drop-down list item.

Turn off the automatic creation of hyperlinks in Excel

Excel automatically creates hyperlinks if you type or insert some text that Excel sees like a hyperlink such as URLs or e-mails. You can easily turn off and turn on the automatic creation of hyperlinks for more comfortable work in Excel ☺.

How to remove green triangles from cells (hide auto-calculating checks)

When you work in Excel, by default it automatically identifies all issues, such as incorrect data in the cell, problems with formulas, etc. So, you see green triangles (by default) shown in the top left corner of these cells.

Easily organize shapes in Excel

Every time you add, move or resize shapes, by default, it isn’t easy to align them. Excel proposes features named Snap to Shape and Snap to Grid that can help to organize shape and any objects.

Change color for gridlines in Excel

By default, gridlines are displayed in worksheets using a color that is assigned by Excel. But if you want, you can change the color of the gridlines for a worksheet (see also How to turn on and turn off gridlines in Excel and How to change width of gridlines in Excel).