Saving as. The whole book ore parts of it??

[Guest]

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?

 

[Mike Middleton]

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

 

[Guest]

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.