Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I save a page in a workbook as a separate file?
I have an Excel workbook with many worksheets. I wish to save just one of
the worksheets as a separate file. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I save a page in a workbook 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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "flowv" wrote in message ... I have an Excel workbook with many worksheets. I wish to save just one of the worksheets as a separate file. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I save a page in a workbook as a separate file?
Hi
Right click on the Sheet tab requiredMove or Copyclick CopySelect New Workbook from the dropdown. You will now be in a new workbook with that sheet included. Save with whatever name you want -- Regards Roger Govier "flowv" wrote in message ... I have an Excel workbook with many worksheets. I wish to save just one of the worksheets as a separate file. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I save a page in a workbook as a separate file?
Hi flowv
You can use this macro http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "flowv" wrote in message ... I have an Excel workbook with many worksheets. I wish to save just one of the worksheets as a separate file. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I save a page in a workbook as a separate file?
Oops, you only want to save one sheet I see now.
Forget my reply -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Hi flowv You can use this macro http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "flowv" wrote in message ... I have an Excel workbook with many worksheets. I wish to save just one of the worksheets as a separate file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving just 1 worksheet out of a workbook to a separate file | Excel Discussion (Misc queries) | |||
How do I save part of a worksheet in a separate file? | Excel Worksheet Functions | |||
Can I auto save to a separate file?(not the file I am working in) | Setting up and Configuration of Excel | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
How do I save sheets in a workbook to separate files? | Excel Worksheet Functions |