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:
Right-click the Sheet tab at the bottom, and select Unhide.
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.