Settings in Excel 2016
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.