Question: how to export an excel sheet?
Answer: Right-click the worksheet name tab. Click select Move or Copy. Click on the Move selected sheets to Book drop-down menu. Select (new book). Click OK. Your new workbook opens with your moved worksheet. ...  Click File > Save in your new workbook.