Settings in Excel 2013 2010 2007 2003

Increase the number of Undo levels in Excel

By default, 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.

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.

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.

Collapse the Ribbon to get more space on screen

When you need as much space as possible on screen to view a document, you can collapse (or minimize) the Ribbon and then restore it very simple.