ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Saving as. The whole book ore parts of it?? (https://www.excelbanter.com/excel-discussion-misc-queries/129386-saving-whole-book-ore-parts.html)

ElFrodo

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?


Mike Middleton

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?




JLatham

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?



All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com