How to save a single worksheet to a new Excel file
- Right click on the Excel worksheet you wish to copy to a new Excel file.
- Select Move or Copy
- Tick the check box Create a copy and select (new book) in the To bookdropdown list.
- Click OK
- Save the Workbook to a new file