Q I use Microsoft Excel for tracking household expenses and other sums, but I find that the little square at the bottom of each entry is sometimes difficult to make into a cross in order to drag it down to the next cell by clicking and dragging, so that I can see a running total.
If the cell used for the calculation of the current total is put either lower
down the sheet, or in an adjoining column, by entering =sum(A22:A32) as an
example, it works, but I wonder if there is a quick way of doing the calculation
in the following cell without clicking and dragging the small cross?
Betty Cowen
A The keyboard can be used to replace AutoFill, when a formula is copied and uses data in cells relative to the original position. This is great for columns of rows of figures. Create the first formula and press Ctrl and C to copy it into the clipboard. Select the other cells by moving to the next cell, holding down Shift then moving to the last cell. This can either be a single row or column. Press Ctrl and V to copy the formula.


Ultimate
Guide to Disc Burning 
Computeractive
Back Issues

Reader comments