Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.
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.
There are currently no FAQs about Excel 2013 Essential Training.
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.