Display or Hide Sheet Tab Bar

This post will guide you how to display or hide worksheet tab bar in Excel. By default, Excel displays each sheet tab at the bottom of the window. And you can click each sheet tab to quickly select that sheet in your workbook. How to quickly turn off or on in your workbook.

#1 click File tab, and select Options from the popup menu list. The Excel Options dialog will open.

display hide sheet tab bar1

#2 click Advanced menu, check or uncheck the Show sheet tabs checkbox in the Display options for this workbook. Click Ok button.

display hide sheet tab bar2

You will see that worksheet tab bar will be displayed or hidden in your workbook.


display hide sheet tab bar3

Leave a Reply