MrExcel Publishing
Your One Stop for Excel Tips & Solutions

saving 1 sheet only as...

Posted by Marc D on April 21, 2001 9:51 AM

Hello again everyone

I would like to know if there is a way to save just 1 sheet from a workbook,

Want I mean is, I have work book with 2 sheet, the first sheet is a Form that I will
Print and want to save for reference, the 2 sheet is my part list witch is 2 Meg if I
Save the complete book every time it will take up to munch space for nothing.

Please help me EXCEL MASTERS
Thank you

Posted by Dave Hawley on April 21, 2001 10:04 AM

Hi Marc

Try this.

1. Right click on the Sheet and select "Move or Copy"

2. Select "New Book" and then click "Ok"

3. Now in this new Workbook go to File>Save as. Type a meaningful name and then select, "Template(*.xlt)"

5. Now close the Workbooks.

Now whenever you are in excel and you want it, just right click on any Sheet name tab and select "Insert" and you will see it.

Is this what you mean ?


BTW 2 Megs is very large for one sheet are you sure it is not corrupted somehow ?
OzGrid Business Applications

Posted by Marc D on April 21, 2001 11:21 AM

This is what I am doing I have sheet 1 set up as a quote form, and sheet2 as part
Numbers and descriptions.
So I import data from sheet2 to sheet1
I need to be able to save a customer quote (sheet1) only in a folder
For reference but not to include sheet2.
I hope that I was able to explain it a little better.

Thanks again for your input !!!

Posted by Dave Hawley on April 21, 2001 11:48 AM

Marc, you can do as I described above and save as a normal .xls file. This will give you a Workbook containing only one sheet.

OzGrid Business Applications