Settings in Excel 365 2013 2010 2007 2003

Increase the number of Undo levels in Excel

By default, the number of Undo levels in Excel 2016 is 100. You can increase or decrease this number if it's necessary.

How to turn off Start screen

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

How to avoid misleading numbers

Applying a number format to a cell doesn't change the value, but only how the value appears in the worksheet. Formatting can play a joke with you, e.g., the sum of values seems incorrect because Excel displays a limited number of decimal places, and their sum is not equal to the real sum.

Changing moving direction of the cell pointer after entering data

Excel automatically moves the cell pointer to the next cell down when you press the Enter key after entering data into a cell, but you can change this behavior to move it up, down, left, right, and even stay on.

Starting Excel without an Empty Workbook

If you prefer to avoid the empty workbook to be created when Excel starts up, you can do so by editing the command line that is used to start Excel.

How to change the number of sheets for new workbooks

Excel 2016 automatically creates one worksheet in each new workbook, but you can force it to create as many worksheets as you need.

Recalculating the worksheet

If you are working with huge workbooks that contain a very large number of formulas, functions, and data, you can turn off automatic recalculation.

Entering decimal points automatically

If you need to enter lots of numbers with a fixed number of decimal places, Excel has a useful tool:

How to change default font

This setting enables you to select a different font and font size for your workbooks.

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.