How do you copy a spreadsheet full of formulas to another without
changing any of the formulas?!!?

Thanks,
Dan

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

I guess it depends on what cells the formula is referencing because on
some it worked and others didn't...

Thanks KC,
Dan

KC Rippstein hotmail com wrote:
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

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