Type one or more text or formulas in the cells. 3. Click OK. How to Save Just One Worksheet in Excel to a Separate File (4 Handy) The following instructions are for Excel 2023 or earlier. These instructions can be used to import into Excel 2007, 2008, or 2023 and even Excel 2013. Step 1. Add the worksheet (worksheet tab in the sheet tab bar) to an Excel workbook. How to save just 1 worksheet in a workbook in Excel? 1. Double-click on the sheet tab in the sheet tab bar. 2. Select the worksheet you want to add to the Excel workbook, then click on the Move or Copy button. How to Save Just One Worksheet in Excel · Second, click on your workbook name in the ribbon at the top left of the screen (sheet1). 3. Click on the sheet tab (the worksheet you are setting as the new workbook) you want to use for the saved worksheets (sheet1 in this example). 4. Click on the Move or Copy button to save the worksheet into a new workbook. 5. Click on File > Save in your new workbook. 6. Copy the save-as and paste the saved-to-new-workbook, or save-to-original-workbook file, right-click on the new workbook tab you just created, and select Move or Copy, to your worksheet in the worksheet tab bar. How to Save just one worksheet in Excel to a Separate File (6 Handy How to Export and Save Each Worksheet as Multiple New Worksheets In Excel 2023 or earlier, if you want to save an entire worksheet as a new worksheet (an Excel worksheet for you), you can copy the entire worksheet to a new workbook, copy all the columns to new worksheets, add all the formulas, and make changes in place, all during import. This is referred to as “automatic importing of worksheet into workbook”. That's what most people will be doing in our typical example. Step 1. Right-click the sheets tab (the worksheet tab with the sheets you want to import into the workbook into).