Open Excel for Mac 2016 with a Blank Workbook Automatically
Question details
Set Excel for Mac 2016 to open a blank workbook instead of the Workbook Gallery.

- Product
- Microsoft Excel for Mac 2016
- Device & OS
- Mac
- Scenario
- The user wants to start Excel with a new blank workbook without selecting one from the Start screen.
- Observed behavior
- Excel displays the Workbook Gallery when it opens.
Open Excel for Mac 2016 and make sure Excel is the active application so its menu appears at the top of the screen. Menu names and options may differ in other versions.
Disable the Workbook Gallery in Excel Preferences
Use Excel’s Mac preferences to open a blank workbook instead of the startup gallery.
In the menu bar, choose Excel > Preferences.
Under Authoring, select General.
Clear the Open Workbook Gallery when opening Excel checkbox, then close Preferences.
Quit Excel and reopen it to verify that a new blank workbook appears.

Work with Blank Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for creating and editing spreadsheets. Its Microsoft Office format support helps you move existing files into WPS Office.

Frequently Asked Questions
Where is the startup setting in Excel for Mac 2016?
Choose Excel > Preferences in the Mac menu bar, then select General under Authoring. Clear Open Workbook Gallery when opening Excel.
Why can’t I find File > Options on my Mac?
File > Options is a Windows menu path. In Excel for Mac 2016, use Excel > Preferences instead.
How do I restore the Workbook Gallery at startup?
Go to Excel > Preferences > General and select Open Workbook Gallery when opening Excel.
Will these steps work in newer versions of Excel for Mac?
The preference name and location may differ in newer versions. Check Excel > Preferences or Settings for a startup or workbook gallery option.




