Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Can you save 1 sheet from a large file into another file?

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 38
Default Can you save 1 sheet from a large file into another file?

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 524
Default Can you save 1 sheet from a large file into another file?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I get a macro to save a sheet and set the file name? MadasMax Excel Discussion (Misc queries) 1 September 16th 07 12:04 PM
Save a large file Kassandra Excel Discussion (Misc queries) 3 April 23rd 07 09:14 PM
copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file [email protected] Setting up and Configuration of Excel 0 March 14th 07 02:13 AM
Web Excel file too large to download to one sheet cary Excel Discussion (Misc queries) 1 July 28th 06 11:36 PM
Q: save a sheet to a file JIM.H. Excel Discussion (Misc queries) 2 October 25th 05 03:12 PM


All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"