Gobe Productive User's Guide - Insert, Delete, Move & Go to 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

# Insert, Delete, Move, and Go to Cells

Insert Cells | Delete Cells | Move Cells | Go to Cells

## To Insert Cells

1. Select the location where you want to insert a cell(s).
2. Select Insert Cells from the Options menu.
3. Choose to Shift Cells Down or Right.

## To Delete Cells

1. Select the cell(s) you want to delete.
2. Select Delete Cells from the Options menu.
3. Choose to Shift Cells Up or Left.

| NOTE: The contents of the adjacent cells will be shifted Down or Right, or Up or Left, depending on which choice you make. If you select a whole column or row and choose Insert or Delete Cells, a new column or row is inserted or deleted.

## To Move Cells

1. Select the cell(s) you want to move.
2. Select Move Cells from the Options menu.
3. Enter the cell address where you want the selected cell(s) to be moved to. Click OK.
4. The selected cell(s) are moved to the new location.

- Another way to move cell(s) from one location to another, is to select the cell(s) and then go to the location that you want them moved to. Right click on the new cell location. Select Move Cells Here from the displayed popup box. The selected cell(s) are moved to the new location.

| IMPORTANT: When moving cells, remember that the data in the cells being moved replaces the data of the cell you are moving to.

## Go to Cells

1. Select Go to Cells from the Options menu.
2. Enter the cell address that you want to go to. Click OK.
3. The selected cell is highlighted.

Copyright © 1999, Gobe Software, Inc