![]() ![]() Now that you've locked/unlocked the cells that you want users to be able to edit, you want to protect the sheet. I share some shortcuts to make this process faster in the Bonus section below. Since cells are locked by default, most of the job will be going through the sheet and unlocking cells that can be edited by users. If you want users to be able to edit a particular cell or range, uncheck the Locked box so they are unlocked. Once we protect the worksheet (in the next step) those locked cells will not be able to be altered by users. Locked is the default setting for all cells in a new worksheet/workbook. Next, make sure that the Locked option is checked. This will bring up the Format Cells window (keyboard shortcut for this window is Ctrl + 1.). Right-click on the cell or range you want to change, and choose Format Cells from the menu that appears. Step 1: Lock and Unlock Specific Cells or Ranges Here's how to prevent users from changing some cells. It's easy to do, and it involves two basic steps: The great news is that you can lock or unlock any cell, or a whole range of cells, to keep your work protected. This is especially true for cells that contain formulas and special formatting. If you share your spreadsheets with other users, you've probably found that there are specific cells you don't want them to modify. Lock-Cells-and-Sheet-Protection-Quote-Example.zip Download Protecting Your Work from Unwanted Changes
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |