- Apr 29
Unhiding Sheets is Now Easier in Excel
- Neale Blackwood
- Tips & Shortcuts
- 0 comments
Not sure when this change happened but it is now much easier to unhide multiple sheets in Excel.
Sign up to hear about free Excel training.
I won't share your email with anyone.
In the past you had to use tick boxes to select sheets unhide. On click per sheet. Now you can just use the Ctrl or Shift keys to select multiple sheets to unhide.
In the image below you can see that the tick boxes have been removed and just the sheet names are listed.
You can hold the Ctrl key down to select individual sheets to unhide. Or use the Shift key to select the first and last sheets to unhide. You can also use Shift and the arrows keys.