Click on the Protection tab within the Format Cells dialog box. Right click on any area that is selected and choose Format Cells.ģ. Hold down the Ctrl key to select non-contiguous ranges as seen in the screenshot below.Ģ. First, select the ranges of cells that you would like users to be able to select and enter data. Once protected, the best practice is to save this document as a template.ġ. We don’t want them to be able to select cells that include formulas…only constant values that pertain to them. We only want staff members to be able to enter their name, month, commute miles, and other specifics about the expense submission. Take this Employee Mileage Reimbursement Form, for example. Then, users only have the ability so select the cells that you decide. Check out how to first unlock cells and then protect the sheet with a password. How do you protect cells on a spreadsheet so that people can only select certain cells? How do you protect cells within a spreadsheet so other people can’t delete your formulas? Gain control of your spreadsheets! The best way is to protect your cells by unlocking them.
0 Comments
Leave a Reply. |