In this article, we will learn to save a worksheet in Excel. Generally, we can save an Excel workbook very easily. But to save a single worksheet in Excel, we need to follow a different method. Today, we will demonstrate 2 handy approaches. Using these methods, you can easily save a worksheet in Excel. So, without any delay, let’s start the discussion.
Download Practice Book
Download the practice book here.
2 Handy Approaches to Save a Worksheet in Excel
To explain the methods, we will use a workbook that contains three worksheets. These worksheets contain information about the Sales, Product, and Project info of a company. We will try to save a single sheet from these sheets in the following methods.
1. Use Context Menu to Save a Worksheet in Excel
In the first approach, we will use the Context Menu to save a worksheet in Excel. This is a simple and easy process. Let’s follow the steps below to learn the technique.
- First of all, right–click on the sheet name in the Sheet Tab bar. A Context Menu will appear.
- Secondly, select Move or Copy from the Context Menu. It will open the Move or Copy dialog box.
- After that, select ‘(new workbook)’ in the ‘To book’ box and check ‘Create a copy’ in the Move or Copy dialog box.
- Click OK to proceed.
- As a result, you will see the desired worksheet in a new workbook.
- In the following step, click on the File tab of the new workbook.
- Now, select Save As and then, select Browse. It will open the Save As dialog box.
- Finally, in the Save As dialog box, type the file name and click on Save.
- Alternatively, you can save the file by pressing Ctrl + S on the keyboard.
- It will open a dialog box. Type the name of the file and click on Save to proceed.
Read More: Excel VBA: Save Sheet as New Workbook without Opening
- How to Open Word Document and Save As PDF or Docx with VBA Excel
- How to Undo Changes in Excel after Save and Close (2 Easy Methods)
- [Fix]: Microsoft Excel Cannot Open or Save Any More Documents Because There Is Not Enough Available Memory
- Excel Macro: Save as PDF with Date in Filename (4 Suitable Examples)
- Save Excel as CSV with Double Quotes (3 Simplest Methods)
2. Apply Excel VBA to Save a Worksheet
Another way to save a worksheet in Excel is to use VBA. VBA lets us perform many long tasks within seconds. Here, we will use a VBA code that will keep the desired worksheet and delete all other sheets from the workbook. Again, we will use the previous workbook to explain the steps. But we will save the Product Info sheet.
So, without further ado, let’s observe the steps below.
- In the first place, go to the Developer tab and select Visual Basic. It will open the Visual Basic window.
- Alternatively, you can press Alt + F11 to open the Visual Basic window.
- In the Visual Basic window, select Insert and then, select Module.
- The Module window will appear.
- After that, type the code in the Module window:
Sub Delete_Others_and_Save_a_Worksheet() Dim SaveWkS As Worksheet For Each SaveWkS In Application.ActiveWorkbook.Worksheets If SaveWkS.Name <> "Product Info" Then SaveWkS.Delete End If Next Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub
Here, the code will delete all other sheets except the Product Info sheet. In your case, write the name of your worksheet that you want to save in place of Product Info in the above code.
- In the following step, press Ctrl + S to save the code.
- After saving the code, hit the F5 key to run the code.
- After running the code, a warning message will pop up.
- Click Delete to delete other sheets one by one.
- After deleting all other sheets, the workbook will contain the desired worksheet mentioned in the VBA code.
- Close the Visual Basic window to proceed.
- Finally, press Ctrl + S to save the single worksheet.
Read More: How to Save Multiple Sheets in Excel (6 Ideal Methods)
Save a Workbook in Excel
Saving a workbook in Excel is very simple and straightforward. Follow the steps below to know how you can save a workbook in Excel.
- Firstly, click on the Save icon on the right–top of the screen or press Ctrl + S on the keyboard to open the ‘Save this file’ dialog box.
- In the ‘Save this file’ dialog box, type a name and choose a location to save the workbook.
- Then, click Save to proceed.
- Alternatively, you can save the workbook using the File tab in Excel.
- For that purpose, click on the File tab in the ribbon.
- In the next step, click on Save As and then, select This PC to save the workbook on your computer. You can also save the file online by using any drive.
- Now, choose the file location. Here, we want to save the workbook in the Documents folder.
- After that, type the file name and choose the file type.
- Finally, click on Save.
Read More: How to Save a Macro for All Workbooks in Excel (with Easy Steps)
Excel File Extensions to Save a Workbook
Generally, Excel saves a file as Excel Workbook (.xlsx). But you can save the file in other formats too. People normally save it in other formats to open the file with other applications.
The most commonly used file types in Excel are discussed below.
- Excel Workbook (*.xlsx): It’s been the default file extension for Excel since 2007.
- Excel Macro-Enabled Workbook (*.xlsm): It contains Excel files with macros. You must apply this format while working with macros.
- CSV (*.csv): This is called comma delimited text file. It is often used to import/export data.
- Excel 97-2003 Workbook (*.xls): Files from Excel 2003 and older use this format.
- Web Page (*.html): In this format, the file is saved as a folder and contains the necessary files and all images.
- Excel Template (*.xltx): Mainly, files with templates are saved in this format.
There are also other file extensions in Excel. You can use the extension according to your need to save a workbook in Excel.
Read More: Excel VBA to Save as File Using Path from Cell (With Quick Steps)
In this article, we have demonstrated 2 handy methods to Save a Worksheet in Excel. Here, we have also discussed the way to save a workbook and different file extensions available in Excel. I hope these methods will help you to perform your tasks easily. Furthermore, we have also added the practice book at the beginning of the article. To test your skills, you can download it to exercise. Follow the ExcelDemy website for more articles like this. Last of all, if you have any suggestions or queries, feel free to ask in the comment section below.
- Excel VBA to Save File with Variable Name (5 Examples)
- How to Save Excel as PDF Fit to Page (5 Easy Ways)
- How to Save Excel File in XLSX Format (4 Easy Methods)
- [Fixed!] Why Is Excel Not Saving My Formatting? (7 Possible Reasons)
- How to Save Excel as PDF Landscape (With Quick Steps)
- How to Undo a Save in Excel (4 Quick Methods)