![]() |
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? |
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? |
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