To rearrange the order of rows in a list, Sort commands gives you numerous options to order the list by content, color, or based on a custom list.
- [Instructor] Excel has two major protection features. They're found on the Review tab in the Ribbon. One, Protect Sheet, protect the current worksheet. One called Protect Workbook. The first one is a bit more powerful. It has to do with the content of a worksheet. In this worksheet here, imagine, you're in charge of this file, you have some trusted assistants who, from time to time, are gonna do the editing and making changes here. You've got a list of changes. A few things you're concerned about. You don't want anybody typing over the formulas that are in column E.
Now they will change automatically, if the column D data changes, but we wanna protect these cells here. Similarly, that Salary data, you don't want any changes being made there. The Job Rating is even more sensitive, perhaps, than the Salary. We don't want that there either. Now we might consider hiding the column, but the whole protection scheme begins with this idea. Any cell in an Excel Worksheet, unless you've altered it, has the attribute of being locked. Right click any cell, anywhere, and go to Format Cells. If you go to the Protection tab you'll see that it's locked.
But it has no meaning until you protect the worksheet. So we're on the path of protecting the worksheet. If all the cells are locked we won't be able to do anything with any of the cells. So let's click in the upper left hand corner and unlock all cells. Right click, Format Cells. Let's unlock them. All cells are unlocked. Before we turn on this Protection feature though, let's lock some cells. We don't want anybody typing in column E, 'til we wipe out those formulas, nor do we want anybody typing those Salaries.
With the Control Key we'll click column G. Right click and Format Cells. Protection, we're going to lock those. And we don't even want column H to be visible, so we Right click column H and hide it. We're ready to turn on Protection. Protect Sheet. We will give it a password. But we also see some other choices here. Should we allow any other user to insert columns and rows? If we do, we'll check some of these other boxes. At a minimum here, if you want to allow changes there must be a check in front of that second box Select Unlock Cells.
And you'll discover whether you want to allow them to click on the lock cells as well, for the moment we can. Password to Protect? Let's provide a password. Enter, we need to provide it again, Enter. We're now in a state where this worksheet is protected, and the Ribbon will look different. For example, my Home tab. Many features are inhibited right now. So another user is making changes here. That user might say, well I know this has to be adjusted to be 2003. That means the year here is gonna change. When you see this, by the way, it might be a later reading, but if I type in a 15 here.
Can't actually type there at all. It's locked and we're protected here. This is my friend, I'll change his salary to be 75,000. I start typing. Can't do that, it's protected. And I'm curious, what's between columns G and I? I'll drag across, Right click. Well, can't unhide, so we can't see that data. At some point, this is back in your hands. What do you do? You go to the Review tab and Unprotect the Sheet, and of course you would know the password. Now, when you protect a workbook, that's really about structure.
This'll prevent adding and deleting sheets, putting in new ones, moving them. If we Protect a workbook, we provide the password here. Enter, provide it again. The workbook is now protected. If I Right click on the current sheet because I want to insert a new one, we can see we can't do that. Can't delete, can't rename, can't move or copy. Can't even change the tab color. And is there a hidden sheet that I wanna get to? We don't even know because that feature, the Unhide feature, is inhibited as well.
So there's a difference in how we use these two features, but I think you can see they both have a role to play because we're concerned about the security of our data. Protect a Workbook. Or Protect a Worksheet.
- Navigating Excel tabs and menus
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros