MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2020: Settings in the Excel Options Menu

December 24, 2020 - by Bill Jelen

Excel Settings in the Excel Options Menu. Photo Credit: Manuel Boxler at

Consider a few of these settings after you choose File, Options:

General, Start Up Options, Unselect Show The Start Screen When This Application Starts to skip the Home screen. Excel will open directly to a blank workbook. (Thanks to Dave Marriott)

Advanced, Editing Options, Unselect After Pressing Enter, Move Selection. When you type a value in a cell, Excel will stay in the same cell. (Thanks to Ed Hansberry)

Advanced, Editing Options, Automatically Insert a Decimal Point. You type 12345. Excel gets 123.45.

Title Photo: Manuel Boxler at

This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.

Bill Jelen is the author / co-author of
Excel Insights – A Microsoft MVP Guide to the Best Parts of Excel

There are fewer than 100 Excel MVPs worldwide. 24 of them have contributed to this book. Written, edited, reviewed and printed by Excel MVPs, this is practical Excel passion undiluted, with each MVP highlighting some of their favorite topics.