View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
KC Rippstein hotmail com> KC Rippstein hotmail com> is offline
external usenet poster
 
Posts: 168
Default Copying Formulas

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