Apple AppleWorks 5 : Windows 95/NT 4.0 - Manual (Page 141)

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 what and Change to 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 Help menu and type the first few letters of the entry. Double-click the
entry and then double-click a 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
Ctrl+Alt and 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