Saving your work is among the most crucial things you can do while creating a spreadsheet. The Save command can be used in three different forms in Excel:

  • On the QA (Quick Access) Toolbar, click the Save button (the one with the disc icon).
  • Ctrl+S or F12 are the shortcut keys.
  • Save the file by clicking the file.

Press Ctrl+S or File when you select the Save button. Save Excel displays the Save As box in the backstage mode for the first time, as seen in Figure below. Excel 2021 saves the new workbook to the Project directory on your One Drive by the standard.

Click the Browse link at the bottom of the Other Locations box to save the file directly — on your portable hard drive or a virtual disc on your firm’s local area network. You can choose the disk and directory where the new workbook should be saved from the Save As dialogue box, which appears with the default location for storing workbook files (see Figure below). Before you save the workbook, use this dialogue box to substitute the short term document name (Book11, Book22, and so on) with a more explanatory filename in the File Name text box; to choose a new file type from the Save As Type drop-down list view; and, if essential, to choose a new folder where it will be saved.

When you’ve finished updating in the Save As dialogue box, hit Enter or select the Save button to store your work in Excel 2021. When you save your workbook file, Excel stores all of the content in each worksheet (such as the last location of the cell pointer) to the specified folder and drive.

Workbooks Saving in Other File Formats

Excel displays a broad selection of file formats that you can pick from when saving the workbook file when pressing the Save as Type drop-down button in the Save As dialogue box. You could use these file types choices to transform your worksheet data into a format that can be read by programs other than Excel 2021.

The following are some of the most regularly used file formats:

  • Open Document Spreadsheet:  Will save your workbook in ODF (Open Document Format) with an .ods filename extension, which is compatible with other Office suites, including Sun Microsystems’ Star Office.
  • XPS Document:  Will save your workbook as an XPS (XML Paper Specification) file with the .xps filename extension, which is utilized by many printers, including Microsoft Office products, to render the data in a document.
  • Adobe PDF:  The workbook is saved in the Adobe PDF (Portable Document File) format, opened with the free Adobe Reader tool.
  • Excel Macro-Enabled Template:  You will save your workbook as an .xltx template file with all macros turned on.
  • Excel Template:  Saves the workbook as an Excel template file in the .xltx file format, which you may use to create new workbooks with the same layout and content as the template.
  • Web Page:  Saves your workbook in HTML (Hypertext Markup Language), which is used to output all of the data from all worksheets in a single cohesive web page with the.htm or.html filename extension.
  • MIME HTML:  Saves the workbook into a MIME HTML (Multipurpose Internet Mail Extension Hypertext Markup Language) file with the .mhtm or .mhtml extension. Some web browsers (notably Internet Explorer) employ this specific HTML structure to simulate the worksheets in the original workbook by using tabbed pages in the generated web page.
  • XML Data:  Saves the workbook in the XML (Extensible Markup Language) format (.xml filename extension), commonly used to send data lists over the Internet.
  • Excel 97–2003 Workbook:  Saves the workbook in the.xls file format, compatible with previous versions of Excel 97 through Excel 2003. Note that if Excel detects any features in the workbook that aren’t supported in this file format, an alert dialogue box appears.
  • Excel Binary Workbook:  This option saves the workbook in a binary file format that allows for faster loading of extremely big workbooks containing a lot of data.
  • Excel Macro-Enabled Workbook:  This option saves the workbook in the default.xlsm file format, with all macros, enabled.
  • Excel Workbook:   It will save your workbook as an .xlsx file in the default Excel 2021 format.

Storing a New Workbook in an Old File Format

Every new workbook file in Excel 2021 is automatically saved in a Microsoft version of the XML-based file format, with the filename extension .xlsx. The issue with this XML file type is that Excel versions cannot open it before 2007. This implies that if everyone who needs to work with the new workbook hasn’t upgraded to Excel 2007 or 2010, you’ll have to save it in the older file format used in Excel versions 97 through 2003, with the old.xls filename extension.

Select the Save as Type drop-down icon and then pick Excel 97-2003 Workbook from the drop-down menu and save a new workbook in the old binary Excel file type for back support.

By admin