• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

How to Hide Worksheets in Excel

August 26, 2021 by Andrew Childress
Hide worksheets in Excel

Keeping your Excel workbook neat and tidy is a big benefit to the user. Let's learn how to hide worksheets in Excel before you press send.

Keeping your Excel workbook neat and tidy is a big benefit to the user. Instead of overwhelming the recipient with many tabs and sheets, it’s a great idea to hide worksheets in Excel before you press send. You won’t disrupt the data in your workbook, but hiding the extra sheets will make it much easier to navigate your file.

You might already know that an Excel file is also called a workbook. Inside a workbook, you typically have multiple worksheets that are on their own tab. Think of an individual sheet like a tab in your web browser. Each gives you a separate space to work, and they don’t disappear just because you switch tabs. Each tab at the bottom of the workbook is a separate sheet. Let’s learn how to hide worksheets in Excel.

How to Hide Worksheets in Excel

Expert Excel users are careful about how they organize their workbooks. You can write formulas that link to multiple tabs and work between worksheets seamlessly. Typically, it’s best to do your calculations on one set of sheets and your presentation (charts, tables, graphs) on a separate spreadsheet. Spreadsheet hygiene helps avoid confusion and saves the viewer time.

 

If you’re sending the workbook to someone else, it’s also a great idea to hide worksheets in Excel. Remember that each tab is located at the bottom of the workbook and you can hide each of them individually.

To hide worksheets in Excel, right-click on a tab and choose Hide. You’ll see the worksheet disappear, but don’t worry – it’s still safe and sound. It’s just out of view so that you can navigate easily.

Hide worksheets in Excel

If you need to unhide a worksheet, just right-click in the area below the worksheet and choose Unhide. You’ll see a list of hidden spreadsheets, and just select the one to bring back into view.

How to Hide Multiple Worksheets in Excel

Want to hide multiple worksheets in Excel? No problem. Just hold Control on your keyboard (or Command on macOS) and click on multiple sheets. You’ll see them highlighted. Then, right-click and choose Hide again. This will hide all selected sheets.

hide multiple worksheets Excel

Remember: hiding your worksheets makes it easier to use your workbook. Spend a few minutes cleaning your sheets before pressing send so that your data is easier to view and navigate.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « PMT function in Excel PMT Function in Excel
Next Post: Change Row Height in Excel Change row height Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2022 · Excelypedia · All Rights Reserved

Back to top