Excel 98

S

Sandra Didado

I want to copy an old db formulas into a new db. Is there
a way to copy the whole sheet including the formulas
without the data?
 
B

Bill Lunney

Highlight all the cells by clicking the little square in the upper left
corner of the worksheet (where the axis join).

Choose Copy

Got to your new sheet

Choose Paste Special > Formulas

If necessary paste the formats etc. as well.



--
Regards,


Bill Lunney
www.billlunney.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data consolidation 0
Copy addition formula of non-consecutive horizontal cells 2
how to copy and paste value from one sheet to another 4
Consolidation Table from Different Excel Tabs with Different Format 1
Autonumber field in Excel that behaves the same as Access 0
Embed the same Excel multiple times 0
Need Help with a VBA subroutine 0
Copying Portions of Data 0

Top