Office for Mac Issues

Open Excel for Mac 2016 with a Blank Workbook Automatically

Kushani NimanthikaKushani Nimanthika Nov 20, 2026 869 views

Question details

Set Excel for Mac 2016 to open a blank workbook instead of the Workbook Gallery.

Open Excel for Mac 2016 with a Blank Workbook Automatically
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.
Before you start

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.

Solution 1Recommended

Disable the Workbook Gallery in Excel Preferences

Use Excel’s Mac preferences to open a blank workbook instead of the startup gallery.

1
Open Excel Preferences

In the menu bar, choose Excel > Preferences.

2
Open General settings

Under Authoring, select General.

3
Disable the gallery

Clear the Open Workbook Gallery when opening Excel checkbox, then close Preferences.

4
Check the startup behavior

Quit Excel and reopen it to verify that a new blank workbook appears.

Disable the Workbook Gallery in Excel Preferences
Mac settings differ from Windows: Excel for Mac 2016 uses Excel > Preferences rather than the Windows File > Options menu.
Free Microsoft Office alternative

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.

Create blank spreadsheets in WPS SpreadsheetsOpen and edit Microsoft Excel formats, including XLSX and XLSUse a familiar spreadsheet interfaceWork with existing Office files in a lightweight application
microsoft office alternative - 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.