Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. On Jan 16, 4:30 pm, imktew wrote: 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? |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? Yes. Edit | Move or Copy Sheet. Check "make a copy" and select "new workbook". Then save the new workbook. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I get a macro to save a sheet and set the file name? | Excel Discussion (Misc queries) | |||
Save a large file | Excel Discussion (Misc queries) | |||
copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
Web Excel file too large to download to one sheet | Excel Discussion (Misc queries) | |||
Q: save a sheet to a file | Excel Discussion (Misc queries) |