Arrow left
Back to guides
Excel Tips

How to Hide and Unhide Sheets in Excel

Learn the quickest way to hide and unhide tabs in Excel.

Why do worksheets in Excel need to be hidden?

When working with excel workbooks that contain multiple tabs, it is often easier to navigate through the file when less important tabs are hidden. By doing so, the user can focus on the most important sheets without getting overwhelmed with the less important or irrelevant sheets.

Hiding sheets in Excel

Step 1: Select the tab you wish to hide

You can also select multiple sheets by pressing and holding the “CTRL” (“Command” in case of Mac) key and selecting all the sheets. If you want to select multiple sheets that are one after the other, select the first sheet, hold down the “SHIFT” key, and then select the last sheet.

Step 2: Right-click and select the ‘Hide’ option. The selected tab will be hidden.

Note:

  1. A hidden worksheet can be unhidden anytime and by any user.
  2. A workbook must contain more than one sheet to be able to hide sheets.
Imagine showing how to hide tabs in Excel 

Unhiding tabs in Excel

As mentioned above, any spreadsheet that has been hidden can also be unhidden by any user. To unhide sheets, follow the below steps:

Step 1: Select any tab

Step 2: Right-click and select the ‘Unhide’ option

Picture indicating step 1 and step 2 explained above

Step 3: A list of hidden sheets will appear, select the sheet you wish to unhide

To select multiple sheets, press and hold the “CTRL” (“Command” in case of Mac) key and select all the sheets. To select multiple sheets that are in sequence, select the first sheet, press and hold the “SHIFT” key and then select the last sheet.

Step 4: Click on ‘OK’

Picture indicating step 3 and step 4 explained above

Analyze your live financial data in a snap in Google Sheets

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows, update numbers in real-time, and save time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. Are you interested in this product but are an Excel user? That’s not a problem at all. You can connect Google Sheets to Excel quickly. 

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

You can learn about other Excel and Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below