Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Saving as. The whole book ore parts of it??

This is maybe a stupid question, but is there some way to save only parts of
the sheet/book?
I.e. if I have sheet with a duty list and round the duty list there is other
stuff I need but dont need to save. Is there a way to just €śSave as€ť the
duty list and not the whole book?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 762
Default Saving as. The whole book ore parts of it??

ElFrodo -

One method is a two-step process. First, choose Edit | Move Or Copy Sheet,
and create a copy in a new workbook. Second, save the new workbook.

- Mike
http://www.mikemiddleton.com

"ElFrodo" wrote in message
...
This is maybe a stupid question, but is there some way to save only parts
of
the sheet/book?
I.e. if I have sheet with a duty list and round the duty list there is
other
stuff I need but don't need to save. Is there a way to just "Save as" the
duty list and not the whole book?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default Saving as. The whole book ore parts of it??

Another way that adds a step or two in front of what Mike wrote, can help if
the information in the duty list comes from formulas that reference the
"other stuff":

Insert a new worksheet into the workbook. Go back and select the cells you
want to copy from the duty list. Back to the new sheet and use Copy | Paste
Special and select the [Values] option. Now move that new sheet as Mike
suggested.

"ElFrodo" wrote:

This is maybe a stupid question, but is there some way to save only parts of
the sheet/book?
I.e. if I have sheet with a duty list and round the duty list there is other
stuff I need but dont need to save. Is there a way to just €śSave as€ť the
duty list and not the whole book?

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
Replace Old Part Numbers with New Part Numbers in a Macro. Jeffery Keown Excel Discussion (Misc queries) 5 October 17th 06 03:45 PM
linking multiple books (source.xls) to a single book (destination. mday Excel Discussion (Misc queries) 4 August 25th 06 04:31 AM
book selection when using move or copy tab in excel Morninglight67 Excel Worksheet Functions 0 October 28th 05 09:15 PM
my excel work book is NOT read onlyt says it is when saving to CD Soo Excel Discussion (Misc queries) 2 September 16th 05 05:29 PM
Not sure which function and how to use it. Help Damon Johnson Excel Worksheet Functions 2 July 25th 05 11:09 PM


All times are GMT +1. The time now is 11:19 AM.

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"