Apple M9057 User Manual - Page 153
Moving data
UPC - 718908500040
View all Apple M9057 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 153 highlights
Spreadsheet 7-7 To Check spelling Find and change cell data Find data that matches a selection Do this Choose Writing Tools from the Edit menu and then choose Check Document Spelling. 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. Select a cell or text, choose Find/Change from the Edit menu, and then choose Find Selection. 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. In the Help index,* see: E entering spreadsheet data E transposing rows and columns 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.) 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. * Choose Index from the or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.