Apple M9057 User Manual - Page 155
Formatting cell data, Fill Down, Fill Right, Fill Special
UPC - 718908500040
View all Apple M9057 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 155 highlights
In the Help index,* see: E filling cells Spreadsheet 7-9 To copy cell contents-including formulas-into adjacent cells, drag to select the cells with the data to duplicate and continue dragging down or to the right over the cells you want to fill. Then choose Fill Down or Fill Right from the Calculate menu. Result of a formula Selected cells Fill Right AppleWorks copies the formula to the selected cells Use the Fill Special command in the Calculation menu to fill cells with: 1 a logical series of numbers, times, or dates 1 a day (Monday), month (January), or quarter name (Qtr 1) 1 any pattern of text or data For example, you can prepare a schedule by filling a range of cells with times and another range of cells with the days of the week. To fill a range of cells with a logical series or a repeated pattern of data, select the cells and then choose Fill Special from the Calculate menu. Select options and click OK. For a complete description of the Fill Special command, see onscreen Help. Fill Special Cells filled with a sequence of times Selected cells AppleWorks fills the selected cells with data Formatting cell data In the Help index,* see: E spreadsheets E spreadsheets, formatting You can change the format of any part of your spreadsheet. Start by selecting the cell, cell range, column, or row that you want to change. * Choose Index from the or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.