Unhide multiple worksheets

Published Mar 24 2021 08:22 PM 58.8K 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.

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