skip to Main Content

Where are the sheet tabs in my Excel template? How can I add a new one?

In most of our templates, we hide Excel sheet tabs and put navigation buttons instead. We prefer this approach due to some technical advantages and also more professional look.

For example:

someka-help-navigation

But if you want to see the sheet tabs, you can easily display them as explained below.

For Windows users:

Go to File > Options > Advanced, and under Display options for this workbook, and make sure the Show sheet tabs check box is selected.

someka-help-sheet-tabs-windows

For Mac users:

Go to Excel (from menubar) > Preferences > View > Select Show Sheet Tabs

someka-help-sheet-tabs-mac

Still, don’t see the sheet tabs?

If you have enabled the Show Sheet Tabs option and still don’t see the tabs, then probably you arranged the Excel window so that the tabs are not present on the screen. In this case, simply maximize the Excel window by double-clicking on the workbook’s title bar.

If you still don’t see the tabs, click View > Arrange All > Tiled > OK

For a further explanation check this out: Where are my worksheet tabs? – Microsoft Office

I found the sheet tabs. But how can I add a new one?

After displaying the sheet tabs and unlocking the workbook, you may add new sheets to you Excel template.

To add new sheets, click on the plus (+) sign and the new sheet will be added to your Excel workbook:

add_new_sheet

The sheet I want to work on is a hidden sheet, how can I view it?

To avoid confusions, we mostly hide calculation sheets and other sheets that are not useful for our customers to fully use the template.

To view a hidden sheet, first display the sheet tabs.

Following that just right click on any sheet tab and select Unhide to see and unhide the hidden sheets:

unhide_sheets


Go back to FAQ Center