View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dan R. Dan R. is offline
external usenet poster
 
Posts: 220
Default Copying Formulas

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