Can you save 1 sheet from a large file into another file?

I

imktew

I received a large file with several different sheets. Is there a way to
save the one sheet to another file without having to save it and remove all
of the extra sheets?
 
R

reitanospa1

Restore the window so you can see the gray area behind the workbook
and [Ctrl]+drag the tab for the sheet you want into the gray area:
Excel will make a new workbook with that one sheet and you can save it
under whatever name you choose. Be careful that you hold down the
Control key while you drag or it will MOVE the sheet instead of
copying it.
 
S

Stan Brown

Wed, 16 Jan 2008 13:30:01 -0800 from imktew
I received a large file with several different sheets. Is there a way to
save the one sheet to another file without having to save it and remove all
of the extra sheets?
Click to expand...

Yes. Edit | Move or Copy Sheet. Check "make a copy" and select "new
workbook". Then save the new workbook.
 

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

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Time required to 'save as' a large file 4
Creating a template that I can reproduce every month by keying ininformation from SAP 8
Dependent drop down dynamic range formula, off sheet. 7
Saving sheet data to another sheet automatically 7
Is there a way to create individual files from a multi sheet excel 1
File placement with copied sheets 1
Auto saving sheets from a workbook as separate files. 1

Top