Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

How Do I transfer all excel page formulas?

Apr 17, 2011 6:56AM PDT

am looking for a way to transfer/copy all formulas used in one page of my excel workbook to a different page of the same workbook. I want the formulas to apply to all the same boxes and such but not change the data from the old page.

Discussion is locked

- Collapse -
Answer
Have you tried
Apr 17, 2011 11:00AM PDT

the 'Paste Special' .....formulas or formulas and number formats?

VAPCMD

- Collapse -
Answer
Can't be sure, but
Apr 17, 2011 10:03PM PDT

I believe you can copy a whole worksheet.

I'm not at my machine that has Excel installed at the moment but from memory, if you right click the worksheet tab, (in Excel 2002 the tabs are at the bottom), you will see options, and I think one is to copy the whole worksheet to a new one.

Try that.

Mark