Unhide multiple worksheets

[Urmi Gupta]

The ability to Unhide multiple worksheets at once has been a popular request on UserVoice, and we’re excited to let you know that this feature is now available for Microsoft 365 Subscribers on Current Channel. To get it, you can update to version 16.0.13525 or greater on Windows, and it's also available in Excel for the Web. On Mac, the feature is rolling out to full availability on versions 16.45 or greater.

To unhide more than one sheet, follow these easy steps in any workbook that contains hidden worksheets:

1. Right-click the Sheet tab at the bottom, and select Unhide.

2. In the Unhide dialog box,  

   -          Press the Ctrl key (CMD on Mac) and click the sheets you want to show, or

   -          Press the Shift + Up/Down Arrow keys to select multiple (or all) worksheets, and then press OK.

If you have additional suggestions, please use the feedback button on the Help tab of the ribbon to let us know.

[Ilgar_Zarbaliyev]

Great!

[Oz du Soleil]

NICE! :party_popper:

[RecalcOrDie]

[jsridhar]

I tried this but it does not work for me. I have a licensed Microsoft365. What could be the reason?

[Wyn Hopkins]

Hi @Urmi Gupta ,  it would be useful to also flag which channels this has been released to as of today in order to address questions such as @jsridhar has

Cheers

Wyn

[Urmi Gupta]

@jsridhar and @Wyn Hopkins the feature is available to M365 subscribers: to get it, you can update to version 16.0.13525 or greater on Windows, and it's also available in Excel for the Web. On Mac, the feature is rolling out to full availability on versions 16.45 or greater.  @jsridhar what version of Excel are you using? Please help confirm that you are on latest version.  Thanks!

[Wyn Hopkins]

Hi Urmi

The issue will be people really only have control over what channel they have access to

is this insider channel only currently or is it on current channel now?

Thanks

Wyn

[Urmi Gupta]

Hi @Wyn Hopkins  thanks for your question, edited the post for clarity.  It is available to M365 subscribers on Current Channel.  Hope that helps.

[Wyn Hopkins]

Perfect, thanks @Urmi Gupta 

[Sameer_Kuppanath_Sultan]

Thats a great move from MS

[Thomas Kristiansen]

It's great to finally have this :)
I do wish though that an 'unhide all' button was available instead of having to select multiple sheets.

[wahyukuncoro]

this doesn't work for me. i have 16.0.13801.21050 instaled

[Sergei Baklan]

@wahyukuncoro , build number practically doesn't matter, more important on which channel you are. For Current channel I guess it shall work.

[wahyukuncoro]

@Sergei Baklan thanks, just figure that office 365 have 3 update channel. Now its working

This feature help me alot

[sainlara]

For Mac users, the feature is currently rolling out and will be available on versions 16.45 or greater. This new feature will make it easier for users to manage their worksheets and save time by allowing them to unhide multiple worksheets at once, instead of having to do it one-by-one.