MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy sheet all but values


Posted by Ken on November 06, 2001 12:40 PM

I need a way to copy the formatting and formulas. I don't want to copy the values input into cells. Is there a way to do this. When you do paste special and select formulas, it still copies the values input into the spreadsheet.I want to recreate the workbook with all pages and formulas intact, but I need to get rid of all the data.


Posted by Mark W. on November 06, 2001 1:29 PM

Why don't you...

1. Make a copy of the workbook and open it...
2. Right mouse click on any tab and choose "Select
All Sheets" from the popup menu.
3. Choose the Edit | Go To... | Special... Constants
menu command and press [ OK ].
4. Press [ Delete ]

Posted by Barrie Davidson on November 06, 2001 1:34 PM

Mark, didn't work for me if I selected all sheets. However..

Posted by Barrie Davidson on November 06, 2001 1:35 PM

Okay, pressed enter instead of tab...

However, it did work for me if I did this sheet by sheet. Very cool solution, never even thought of the special cells!

Regards,
Barrie

Posted by Ken on November 06, 2001 2:12 PM

Thanks Mark, Genius solution and simple!