Next: 5 Manipulating the Spreadsheet
Up: 4 Entering Data
Previous: 4.8 Entering Graphs
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:
- Check Protection in the Sheet Defaults dialog box
turns cell protection on, thereby affecting cells that
have been designated as protected.
-
The Protection option menu in the Cell Defaults dialog
box applies the selected protection option to all
cells in the sheet.
- The Cell Protection option from the Tools menu
protects, unprotects, or assigns the cell protection default to
selected cells, overriding the setting in Cell
Defaults. However, cell protection must first be
enabled in the Sheet Defaults dialog box for this
setting to have any effect.
To enable or disable cell protection for the entire
spreadsheet:
- Select Sheet Defaults from the Options menu to
display the Sheet Defaults dialog box as shown in
Figure 8.2.
- Click the Check Protection check button on or off.
- Apply your selection by clicking OK or Apply.
To set default cell protection for the entire sheet:
- Select Cell Defaults from the Options menu to display
the Cell Defaults dialog box as shown in
Figure 8.1.
- 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.
- 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:
-
Select the cell or range to be protected.
- Select Cell Protection from the Tools menu.
-
Select Protect from the cascade menu.
To remove cell protection from a selected cell or range:
- Select the cell or range of cells for which
protection should be removed.
- Select Cell Protection from the Tools menu.
- Select Unprotect from the cascade menu.
To apply the default cell protection to a selected cell
or range:
- Select the cell or range to be protected.
- Select Cell Protection from the Tools menu.
- 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: 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