Similarly, if you want certain formulas hidden, you can select the cells and hide their formulas.
If you want only certain cells to be unlocked (for data entry, for example), you can select those cells and unlock them before turning on worksheet protection. If you want to protect every cell, you can leave the formatting as it is and turn on worksheet protection. With this in mind, here are the options you have when setting up your protection formatting: That’s because Excel doesn’t perform the actual lock-that is, it doesn’t prevent users from modifying the cells-until you turn on worksheet protection. Note, however, that “locked” in this context really only means that the cells have the potential to be locked.
#Microsoft excel 2011 paste options password
Protect a range with a password When you use this technique, you protect one or more ranges with a password, and then specify which users are allowed or denied editing privileges on that range.īy default, all worksheet cells are formatted as locked and their formulas are visible. You then turn on worksheet protection, which means that locked cells can’t be changed, deleted, moved, or copied over, and that hidden formulas are no longer visible.
You can also hide the formulas in one or more cells if you don’t want users to see them. Protection formatting When you use this technique, you format those cells in which you want to allow editing as unlocked, and you format all other cells as locked. You can prevent this problem by using Excel’s worksheet protection features, which you can use to prevent changes to anything from a single cell to an entire workbook.įor protecting cells, Excel offers two techniques: When you have labored long and hard to get your worksheet formulas or formatting just right, the last thing you need is to have a cell or range accidentally deleted or copied over.
Objective 1.2: Manage workbook review Restrict editing