Gobe Productive User's Guide - Locking Cells

- Working in the spreadsheet environment
- Formatting cells
- Row & column sizes
- Number formats
- Insert, Delete, Move & Go to Cells
- Locking cells
- Filling cells
- Sorting cells
- Calculating cells & Dependent cells
- Formulas & functions
- Function reference
- Creating a chart
- Working with charts
- Styles
- Named selections
- Display options
- Spell checking
- Writing tools
- Views & layers
- Working with spreadsheet frames

# Locking Cells

Lock Cells | Unlock Cells

A locked cell cannot be edited. Locking cells is very useful if you are working with a large amount of data and wish to safeguard that data from inadvertent changes. It is a good idea to lock cells with complex formulas to avoid accidentally erasing or editing the formulas. Formulas inside locked cells calculate the same as those in unlocked cells.

## To Lock Cells

1. Select the cells you want to lock.
2. Select Lock Cells from the Format menu.

- Once locked, the values in a cell cannot be changed. Formulas inside the locked cells calculate the same as those in unlocked cells.

## To Unlock Cells

1. Select the locked cells you want to unlock.
2. Select Unlock Cells from the Format menu.

- The cells are unlocked.

Copyright © 1999, Gobe Software, Inc