MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Saving a single sheet

Posted by John Petrie on May 09, 2001 2:12 AM

I would like to know if there is a way to save a single sheet in Excel 97, without having to delete all the other sheets beforehand.
Even possibly save all the selected sheets (grouped).
I would like to avoid having to copy the sheet(s) to another workbook as it means additional time and effort in formating the new sheet, particularly for printing.

Thanks, John.

Posted by Dave Hawley on May 09, 2001 7:38 AM

Hi john

not possible withou deleting the unwanted sheets. But if you have grouped the sheets you want save simply right click on any sheet name tab and select "Move or Copy" and copy them to a New Book. The format will be exactly the same as you are copying the sheet Object.


OzGrid Business Applications