How do I save a page in a workbook as a separate file?

  • Thread starter Thread starter flowv
  • Start date Start date
F

flowv

I have an Excel workbook with many worksheets. I wish to save just one of
the worksheets as a separate file.
 
Save the many sheeted workbook with the new name
Now delete the unwanted sheets - right click each tab and use Delete
If you have lots of tabs: click the first one that is to go; hold SHIFT;
click the last one (do not include the required sheet); the right click and
delete
best wishes
 
Hi

Right click on the Sheet tab required>Move or Copy>click Copy>Select New
Workbook from the dropdown.
You will now be in a new workbook with that sheet included.
Save with whatever name you want
 
Back
Top