From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Unhide multiple worksheets at once and use the very hidden option

Unhide multiple worksheets at once and use the very hidden option - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Unhide multiple worksheets at once and use the very hidden option

“

- [Instructor] It's not a bad idea 2 when you open a workbook to check to see 3 if there are any hidden sheets. 4 Now not everybody uses the feature, 5 but there are numerous occasions 6 for wanting to hide a sheet. 7 Sometimes you just don't use the sheet very often, 8 it gets in the way. 9 You might want to hide a whole cluster of sheets. 10 Relatively recently a new feature is introduced, 11 the ability to unhide more than one sheet at a time. 12 Now in this workbook here that I've just opened, 13 I don't remember it very well, 14 I haven't seen it in a long time. 15 I'll right click any sheet tab, 16 doesn't have to be the current one, 17 and choose unhide. 18 If unhide is selectable, 19 in other words if it's in black font rather than gray, 20 at least one worksheet is hidden. 21 In this case, we see three of them. 22 In the past, we could only unhide one. 23 Now, we can unhide all of these. 24 If it's a…

Contents