How to Hide and Unhide Multiple Sheets in Excel Without Macros

Hey everyone, Franco here with Wisdify! If you’re just starting with Excel, you might already be working with complex workbooks. Don’t worry—you can handle it. In this guide, I’ll show you how to hide and unhide multiple sheets in Excel quickly and efficiently, without using macros.

Why Hide Sheets in Excel?

One common scenario is when you’re creating a polished report for a client. You may want to show only the final output while keeping the computations and supporting sheets hidden. Manually hiding sheets one by one can be time-consuming—especially if you’re working with large workbooks that contain data from multiple divisions.

So, how do you hide multiple sheets without wasting time? Let me share a simple trick that I wish I’d learned earlier in my career.

Step 1: Group Sheets in Excel

To work with multiple sheets at once, you first need to group them. Grouping sheets allows you to perform actions like hiding, formatting, or editing across all selected sheets simultaneously.

Option 1: Group Non-Adjacent Sheets

1. Hold the Ctrl key on your keyboard.
2. Click on each sheet tab you want to group.
3. Once selected, the grouped sheets will appear highlighted.

Option 2: Group Adjacent Sheets

1. Click on the first sheet tab you want to group.
2. Hold the Shift key.
3. Click on the last sheet in the range.

Now, all the selected sheets are grouped together!

Step 2: Hide Multiple Sheets

Once you’ve grouped the sheets, hiding them is a breeze:

1. Right-click on any of the grouped sheet tabs.
2. Select Hide from the menu.

That’s it! All the selected sheets will now be hidden in one go.

Step 3: Unhide Multiple Sheets

What if you need to make changes later and unhide those sheets? Don’t worry, it’s just as simple:

1. Right-click on any sheet tab.
2. Select Unhide from the menu.
3. In the dialog box that appears, group the sheets again using Ctrl or Shift.
4. Click OK, and all the sheets will reappear.

Why Grouping Saves Time

Before I learned this trick, I used to hide sheets one by one. It wasn’t until six months into my first accounting job that I discovered grouping sheets. Grouping not only saves time but also ensures consistency when performing actions across multiple sheets.

Final Thoughts

Hiding and unhiding sheets in Excel doesn’t have to be a tedious task. By using grouping, you can simplify your workflow and focus on presenting clean, professional reports.

If this trick helped you, give it a thumbs up, share it with others, and subscribe to our channel for more Excel tips. Have questions or your own favorite Excel tricks? Drop them in the comments below.

Until next time, keep refining your workflows and working smarter. Have a great day!