Blog Post

Excel Blog
1 MIN READ

Unhide multiple worksheets

Urmi Gupta's avatar
Urmi Gupta
Icon for Microsoft rankMicrosoft
Mar 25, 2021

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.

Updated Apr 15, 2021
Version 10.0
Blog
Excel
Unhide
  • jsridhar's avatar
    jsridhar
    Copper Contributor
    Mar 26, 2021

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

  • Urmi Gupta's avatar
    Urmi Gupta
    Icon for Microsoft rankMicrosoft
    Apr 15, 2021

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

  • thomasbkdk's avatar
    thomasbkdk
    Brass Contributor
    Jun 14, 2021

    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.

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Apr 07, 2021

    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's avatar
    Urmi Gupta
    Icon for Microsoft rankMicrosoft
    Apr 12, 2021

    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's avatar
    Wyn Hopkins
    MVP
    Apr 12, 2021

    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