What do you want? For example if the fomula in cell B! references cell A1,
what should it reference after you copy it to, say, cell M16?

Tyro

"Captain Jack Flak" <Captain Jack wrote in
message ...
I often have to create several versions of a report that summarizes data in
slightly different ways. It is easiest to do this by copying an existing
form to another section of the same worksheet, however I cannot stop the
formulas from "adjusting". This is not a case where I want to use
absolute
cell references. Other spreadsheets have a way to copy a range of cells
without "updating" the cell references within the formulas. Is anyone
aware
of a procedure or option, when copying a range of data, that will prevent
references within formulas from updating?