Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If this is your workbook, but others are allowed to see it and work with it, you might have some security concerns regarding the structure of the workbook and even the appearance of certain worksheets. In this workbook called Security&Sharing, the first sheet here is called WorksheetProtection. And there are some formulas in column J that relate to a table, it's actually on another worksheet called TaxTable, see at the bottom of the screen. Now, you don't want that table to be disrupted or altered in any way and you rather not even have others see it.
So what can we do here? We can hide a sheet by Right-Clicking on TaxTable the second sheet from the right, we can choose Hide, and we no longer see it there. At a later time if we need to get this back we can Right-Click and Unhide. And by the way, if you have more than one unhidden sheets you're going to only bring back one at a time. So, we don't want that visible. Now our formula still works, this still refers to the hidden sheet. But, we want others as we said to get to it and furthermore, we don't want the order of the sheets here changed also, we want to keep the same scheme as we see it now.
We do want to allow others to work with this and possibly make some changes. So we're not talking about worksheet protection here, but protecting the workbook. We go to the Review tab and choose Protect Workbook, keep others from making structural changes. And the box for Structure is already checked, we will provide a Password, we don't want others somehow changing this and getting to those hidden sheets possibly, we click OK. There is a password again, we'll put it in again of course and OK. While it's in this state the other person who might be using this or other people might say, gee! I wonder if there is a hidden sheet here.
If we Right-Click any of the sheets here, we don't even have the possibility of seeing whether there's a hidden sheet. We can protect the sheet, that's totally different action but nothing about unhiding, so we can't get to that. And notice also how Insert and Delete and Rename and Move and Copy, all those are inhibited. And we say, yeah but I move sheet by dragging them, well I try dragging this one. You see that symbol, you know you can't do that and similarly with copy as well. And so if we need to get this back of course, we would know the Password, comeback to Protect Workbook and provide the Password to unlock it.
So it's a completely different feature than protecting the worksheet and it's primarily about the structure of a workbook. Back in this state now we could Right-Click one of our sheet tabs and go to Unhide and unhide that particular sheet that we've hidden. So it's a great feature for controlling the structure of a workbook allowing only the sheets that you want to be seen to be seen.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74854 Viewers
80 Video lessons · 129896 Viewers
52 Video lessons · 64075 Viewers
59 Video lessons · 49876 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.