Unhide multiple worksheets

Published 03-24-2021 08:22 PM 4,308 Views
Microsoft

The ability to Unhide multiple worksheets at once has been a popular request on UserVoiceand 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.
Unhide Sheets Gif3.gif

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.

10 Comments
Contributor

Great!

NICE!

I like it.gif

Occasional Visitor

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

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

Microsoft

@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!

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

Microsoft

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

Perfect, thanks @Urmi Gupta 

Frequent Contributor

Thats a great move from MS

Co-Authors
Version history
Last update:
‎Apr 14 2021 05:50 PM
Updated by: