Copying Formulas
That will copy data values as well as formulae. If you want to remove the
values you can use Edit/ GoTo/ Special/ Constants, & then delete.
--
David Biddulph
"KC Rippstein hotmail com" <kcrippstein<atdot wrote in message
...
Two options:
1) right click the worksheet's tab and make a copy of the sheet into
another
workbook
2) select the box above row 1 and to the left of column A; this selects
all
your data; then copy the data, go to your new worksheet, and Edit - Paste
Special - Formulas.
--
Please remember to indicate when the post is answered so others can
benefit
from it later.
"Dan R." wrote:
How do you copy a spreadsheet full of formulas to another without
changing any of the formulas?!!?
Thanks,
Dan
|