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

E

ElFrodo

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?
 
J

JLatham

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.
 
Top