View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default 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