next up previous contents index
Next: 5 Manipulating the Spreadsheet Up: 4 Entering Data Previous: 4.8 Entering Graphs

4.9 Cell Protection

     

NExS lets you protect certain cells in the spreadsheet, allowing cell contents to be viewed but not changed by the user. (Cell values will still be changed by recalculation).

Cell protection is controlled by three operations:

To enable or disable cell protection for the entire spreadsheet:

  1. Select Sheet Defaults from the Options menu to display the Sheet Defaults dialog box as shown in Figure 8.2.

  2. Click the Check Protection check button on or off.

  3. Apply your selection by clicking OK or Apply.

To set default cell protection for the entire sheet:

  1. Select Cell Defaults from the Options menu to display the Cell Defaults dialog box as shown in Figure 8.1.

  2. Move the pointer to the Protection option button. While holding down the left mouse button to display the options, point to desired option and release.

  3. Move the pointer to the Recalc Mode option button. While holding down the left mouse button to display the options point to desired option and release.

To apply cell protection to a selected cell or range:

  1. Select the cell or range to be protected.

  2. Select Cell Protection from the Tools menu.

  3. Select Protect from the cascade menu.

To remove cell protection from a selected cell or range:

  1. Select the cell or range of cells for which protection should be removed.

  2. Select Cell Protection from the Tools menu.

  3. Select Unprotect from the cascade menu.

To apply the default cell protection to a selected cell or range:

  1. Select the cell or range to be protected.

  2. Select Cell Protection from the Tools menu.

  3. Select Default from the cascade menu.


Cells are protected by default. If Check Protection is on, then all cells will be protected until changed.


next up previous contents index
Next: 5 Manipulating the Spreadsheet Up: 4 Entering Data Previous: 4.8 Entering Graphs

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999