Join Dennis Taylor for an in-depth discussion in this video Hide and unhide worksheets securely, part of Excel Tips Weekly.
- [Voiceover] There are times when you might want to…hide a worksheet.…One rationale could be,…this is a workbook that different people use.…I've been doing some experimentation on this sheet,…or that sheet, I don't want others to see this.…I'll simply right-click the sheet,…and choose hide, and it's no longer visible.…I might save the workbook.…When I open it, it's gonna look exactly the way it…looks right now.…There's still that hidden sheet.…I might want to hide multiple sheets.…Maybe I want to hide all these sheets from…random right here, all the way over to concat,…so I'll click the first one,…with the shift key I'll lick the last one.…
All of those are selected.…I'll right-click on the first one,…and hide all of these.…I'm hiding five sheets at once here.…At a later time,…I might want to bring back those sheets.…So, right-click on any sheet tab,…unhide, and although you can hide multiple sheets at…the same time, you can only unhide one sheet at a time.…So, I'll choose randbetween,…click okay, right-click on hide,…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.