Related Topics:

Analysis Workbooks

Cell Protection - Locking and Hiding

You can protect the contents of a cell from being modified and/or viewed. This protection can be applied to all cells in a sheet or just a few.

The locked and hidden attributes for any cell can be configured in advance and then will be applied only if cell protection is enabled for the spreadsheet. By default, every cell attribute is set to locked and not hidden.

To lock/hide and protect cells, do the following:

  1. If cell protection is already enabled, toggle it off temporarily by choosing Sheet > Format and View > More Settings > Enable Protection.

  1. Select the cell(s) you want to configure. Note that if you want to select the whole sheet, click the Select All button.

  1. Choose Sheet > Format and View > More Settings > Cell Protection.

  1. Specify whether the selected cell(s) will be locked and/or hidden when protection is enabled.

While you can use this option by itself, it is more practical to combine it with the locked option to keep the cell's contents from being changed.

  1. Once you have set the type of protection, you can toggle cell protection on and off in the spreadsheet by choosing or clearing Sheet > Format and View > More Settings > Enable Protection.

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.