J
Jan
In previous versions of Excel in a basic spreadsheet I
could type a simple formula into a cell, drag it across
with the handle, and it would extend the formula and fill
in the result (for each column). In Excel 2003 the
formula is copied but not updated for each new column.
Other than double-clicking on each individual cell to
update to the correct range, is there a way to do this
easily?
could type a simple formula into a cell, drag it across
with the handle, and it would extend the formula and fill
in the result (for each column). In Excel 2003 the
formula is copied but not updated for each new column.
Other than double-clicking on each individual cell to
update to the correct range, is there a way to do this
easily?