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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |