Copy the formula You want to perform this same calculation for the remaining months. You will copy the formula to cells C9 through E9. Highlight the range of cells from B9 to E9. Click the first cell you want to highlight, and then drag the mouse to highlight the rest of the cells. On the Edit menu, click Fill Right.
Works copies the formula to the highlighted cells and calculates the difference for each month.
Save the spreadsheet Before you begin working with more files, you should save your spreadsheet. On the File menu, click Save. Select the disk drive and folder where the Works practice files are located. In the File Name box, type Temperature 4. Click the Save button.