Apple AppleWorks 5 : Mac OS - Manual (Page 153)

Spreadsheet 7-7
Note When the insertion point is active in the entry bar, the arrow keys move
the insertion point. Otherwise, the arrow keys select an adjacent cell. To use
the arrow keys to always select cells, choose Preferences from the Edit menu.
In the Preferences dialog box, choose Spreadsheet from the Topic pop-up
menu, select Always Selects Another Cell, and then click OK.
Moving data
You can move selected cells using the keyboard and mouse, or using menu
commands.
Important When you move cells that are part of an absolute reference in a
formula, be sure to move the entire range of cells in the calculation.
Check spelling Choose Writing Tools from the Edit menu and then choose
Check Document Spelling.
Find and change cell data Choose Find/Change from the Edit menu and then choose Find/
Change. Type in the Find and Change boxes, and then click
Find Next or Change All.
Find data that matches a
selection Select a cell or text, choose Find/Change from the Edit menu, and
then choose Find Selection.
* Choose Index from the or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
To Select the cells you want to move and then
Move the cell contents and
retain the original cell
references Choose Move from the Calculate menu. Type the cell address
of the new location (for example,
E22 ), and then click OK. (For
a cell range, type the new location for the upper-left cell in the
range.)
Move cell contents quickly Hold down 2-Optionand click in the cell (or at the top left cell
for a range) where you want the selection to go.
You can also use the mouse to drag the cells to another location
on the spreadsheet.
Transpose a column of data
into a row, or a row of data
into a column Choose Cut from the Edit menu. Then select the target cell or
range and choose Paste Special from the Edit menu. In the Paste
Special dialog box, click Transpose Rows and Columns, and then
click OK. (Transposed data overwrites any existing data.)
To Do this
In the Help index, * see:
E
entering spreadsheet data
E
transposing rows and columns