Copy the formula You want to perform this same calculation for the remaining months. You will copy the formula to cells C9 through G9. Highlight the range of cells from B9 to G9. Mouse Click the first cell you want to highlight, and then drag the mouse to highlight the rest of the cells. From the Edit menu, choose Fill Right.
Works copies the formula to the highlighted cells and calculates the difference for each month.
Plot a chart You can more easily see how numbers relate to one another in chart form. Plot a chart to compare the average high and low temperatures you have recorded. You can then draw some conclusions from what you see. Highlight cells A4 through G8. From the Tools menu, choose Create New Chart.