Settings in Excel 2016 2010 2007 2003

How to customize your local Excel chart settings

Default installation of Excel have reasonable presets for chart types and colors, but you can change those defaults according your own preferences.

How to customize your local Excel

Excel is heavily used by all Microsoft Office users and automatically opened workbooks, customizations of menu, recent documents and start screen allow you to save a lot of time.

How to manage Add-ins

Some function in Excel is available only when the add-in is installed. For example, Solver or the Analysis group is not available in standard ribbons, you need to install the add-in before you can use it. See also Using Solver.

How to turn off Start screen

When you first start most of the Office 2013 applications, you'll see a new feature called the Start screen.

Creating a Drop-Down List in a Cell

This tip will show you how to display a drop-down list in a cell.

How to turn on/off the Quick Analysis Feature

When you select a range of data, Excel displays a Quick Analysis button in the lower-right corner of the range. But this option can be turned off.

How to change default chart

When Excel is installed, the default chart is a 2-D Column chart but you can easily change the default chart type.

Grouping and ungrouping sheets

Sheets can be grouped (connected) to facilitate creating or formatting two or more identical sheets. For example, you can create one sheet and copy it to two other sheets, or you can group three blank sheets and enter and format the content once-no subsequent copying required.

Show or Hide Enhanced ScreenTips

By default, Excel shows document tooltips (or screentips) when you hover on a button, but this option can be turned off.

How to hide/display comment indicators

When a comment has been inserted in a cell, the little red triangle is being displayed to indicate a comment in a cell. This tip is how to hide/display this indicator.