From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Hide and unhide worksheets securely

Hide and unhide worksheets securely - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Hide and unhide worksheets securely

- [Instructor] There are times 2 when you might want to hide a worksheet. 3 One rationale could be this is a workbook 4 that different people use. 5 I've been doing some experimentation 6 on this sheet or that sheet. 7 I don't want others to see this. 8 I'll simply right click this sheet and choose Hide, 9 and it's no longer visible. 10 I might save the workbook when I open it. 11 It's going to look exactly the way it looks right now. 12 There's still that hidden sheet. 13 I might want to hide multiple sheets, 14 maybe I want to hide all these sheets 15 from Random right here all the way over to CONCAT. 16 So I'll click the first one, 17 with the Shift key, I'll click the last one. 18 All those are selected. 19 I'll right click on the first one and hide all of these. 20 I'm hiding five sheets at once here. 21 At a later time, I might want to bring back those sheets. 22 So right click on any sheet tab, Unhide. 23 And…

Contents