MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Settings in the Excel Options Menu

December 12, 2019 - 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

Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point 2nd Edition

Fifteen months after Dynamic Arrays debuted for Office Insiders, the functions are being released to General Availability. This second edition of the book has been updated with new examples: see how Dynamic Arrays make XLOOKUP better. The chapter on the logic behind arrays has been expanded.