Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
linking multiple books (source.xls) to a single book (destination. | Excel Discussion (Misc queries) | |||
book selection when using move or copy tab in excel | Excel Worksheet Functions | |||
my excel work book is NOT read onlyt says it is when saving to CD | Excel Discussion (Misc queries) | |||
Not sure which function and how to use it. Help | Excel Worksheet Functions |