How to Show and Hide the Worksheet Tabs in Excel

how-to-show-and-hide-the-worksheet-tabs-in-excel photo 1

If you’re short on screen space, you may want to hide parts of the Excel window, such as the ribbon and the worksheet tabs. We’ve already shown you how to hide the ribbon, so here we’ll show you how to hide the tabs.

To begin, click the “File” tab.

how-to-show-and-hide-the-worksheet-tabs-in-excel photo 2

On the backstage screen, click “Options” in list on the left.

how-to-show-and-hide-the-worksheet-tabs-in-excel photo 3

On the “Excel Options” dialog box, click “Advanced” in the list of items on the left.

how-to-show-and-hide-the-worksheet-tabs-in-excel photo 4

Scroll down to the “Display options for this workbook” section (not the “Display” section) and select the “Show sheet tabs” check box so there is NO check mark in the box.

how-to-show-and-hide-the-worksheet-tabs-in-excel photo 5

Click “OK” to accept the change and close the “Excel Options” dialog box.

how-to-show-and-hide-the-worksheet-tabs-in-excel photo 6

You can also hide other items in Excel such as cells, rows, and columns and comments, formulas, and gridlines.

More stories

How to Show the Developer Tab on the Ribbon in Office Programs

As its name implies, the “Developer” tab in Office programs allows you to create applications to use with Office programs, write macros, run macros you previously recorded, use XML commands and ActiveX controls, use form controls, and is not available by default.

What is DNS Cache Poisoning?

DNS cache poisoning, also known as DNS spoofing, is a type of attack that exploits vulnerabilities in the domain name system (DNS) to divert Internet traffic away from legitimate servers and towards fake ones.

How to Clean the Dust Out of Your Laptop

If you’ve had your laptop for a year or two, it may be full of dust. Dust clogs fans, vents, and heat sinks, preventing your PC from cooling down properly. You can remove a good amount of this dust, even if you can’t open your laptop.

How to Restore Files From a Time Machine Backup on Windows

Windows normally can’t Time Machine backups — in fact, it doesn’t even understand the HFS+ file system format Macs require on their Time Machine drives. But you can recover all the files from your Time Machine backup on your Windows computer.

Why Can’t I Delete Photos Off My iPhone Anymore?

After years of being able to manage your photos by mounting your iOS device just like a flash drive, suddenly you can no longer delete pictures from your device like you used to. Read on as we show you how to tame your iPhone can get back to managing your files the way you want.

How to Securely Empty the Trash in OS X

OS X has a reputation for being secure. It is, and to its credit it provides quite a few options for making it even more secure, such as the option to securely delete files so they’re much harder, if not impossible, to recover.