Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

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.

Why don't you...

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

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 ]

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

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

Okay, pressed enter instead of tab...

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

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

Thanks Mark, Genius solution and simple!

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.