Using Excel Online

  1. Excel Workbook Examples

in a web browser looks a lot like the Excel desktop app. However, there are some differences to be aware of. For example, not all file formats are supported, and some features may work differently than the desktop app. This article explains these differences.

Note: If you are using Excel Web App or Excel Services in SharePoint Server 2010, see this version of Differences between using a workbook in the browser and in Excel.

File formats that are supported in Excel Online

  • Excel workbook files (.xlsx)
  • Excel 97-2003 workbook files (.xls).
    Note: When you open this file format, Excel Online will convert it to a newer .xlsx file. You can always download the original by going to File > Info > Previous versions.
  • Excel binary workbook file (.xlsb)
  • OpenDocument Spreadsheet file (.ods)
  • Excel macro-enabled workbook (.xlsm)
    A workbook in this format can be opened but macros do not run in a browser window.

Workbooks in other formats, such as .csv format, are generally not supported in Excel Online.

For more information about Excel file formats, see Save a workbook in another file format.

Note: There are limits to the size of files you can view in SharePoint Online and the Power BI service. Read more about file size limits for workbooks in SharePoint Online.

Features that are supported for viewing in Excel Online

When you view or print a workbook in a browser window, some features might work differently, as summarized in the following table.

This feature
Works like this in a browser window
Calculations
Calculations and calculation settings, including automatic, manual, and iterative calculation settings for ranges or worksheets work in a browser window similar to how they do in Excel.
Cells
Serial Search TipsWhen searching for Sysmac Studio License Key do not include words such as serial, number, key, license, code, torrent, etc. Sysmac studio omron. Excluding words such as these will result in much more accurate results.Recheck your spelling for Sysmac Studio License Key just in case, you might also want to try searching without the version number.If you still are having trouble finding Sysmac Studio License Key have a look at the high speed results above, they are completley free and you will most likley find what you are looking for there.
Cells, including cell values, merged cells, and cell content overview, are displayed in a browser window similar to how they are displayed in Excel.
Charts and tables, including PivotChart reports and PivotTable reports
In general, charts, tables, PivotChart reports, and PivotTable reports are displayed in a browser window similar to how they are displayed in Excel. Exceptions include
  • Charts that are part of a group of charts
  • Charts that rely on external references
  • Charts that use certain kinds of data sources that are not supported for workbooks viewed in a browser window
If you are using Excel Services or Excel Web App on premises (not in the cloud), the ability to display certain content in a browser window depends on whether Excel Services or Excel Web App is used to display a workbook. For more information, see Comparing Excel Services in SharePoint to Excel Web App.
Data connections
Depending on how your environment is configured, some kinds of data connections are supported for workbooks displayed in a browser window, which enables you to refresh data. For more information, see Refreshing data in a workbook in a browser window.
Dates
Dates are displayed in a browser window similar to how they are displayed in Excel.
External references
The last known value for an external reference is displayed in a browser window. External references must be updated using Excel.
Fields list for a PivotChart report or a PivotTable report
In general, the Fields List for a PivotChart report or a PivotTable report works in a browser window similar to how it works in Excel. This means that people can use the Fields List to explore information and change the data that is displayed in a PivotChart report or PivotTable report.
Filters, slicers, and timeline controls
Filters and slicers generally work in a browser window similar to how they work in Excel. In general, timeline controls work in a browser window similar to how they work in Excel.
If you are using Excel Services or Excel Web App on premises (not in the cloud), the ability to display certain content in a browser window depends on whether Excel Services or Excel Web App is used to display a workbook. For more information, see Comparing Excel Services in SharePoint toExcel Web App.
Formatting
Cell and cell-range formatting and number formats display in a browser window similar to how they are displayed in Excel.
Functions
Most Excel functions work in a browser window as they do in Excel. Exceptions are listed in the Workbook functions section of this article.
Line borders
Most, but not all, line borders are displayed in a browser window as they are displayed in Excel. Line colors, continuous- and double-line styles, solid and dashed lines, and lines using thin, medium, and thick line weights are supported.
Named items
Named items, such as ranges, tables, charts, PivotChart reports, PivotTable reports, slicers, and timeline controls are generally displayed in a browser window similar to how they are displayed in Excel.
If you are using Excel Services or Excel Web App on premises (not in the cloud), the ability to display certain content in a browser window depends on whether Excel Services or Excel Web App is used to display a workbook. For more information, see Comparing Excel Services in SharePoint toExcel Web App.
Sparklines
Sparklines display in a browser window similar to how they are displayed in Excel.
Tables
Excel tables, including data, column headers, and total rows are displayed in a browser window similar to how they are displayed in Excel.

Features that can differ between the browser and the desktop

Some features work differently in a browser window than they do in Excel. In addition, some workbook features can prevent a workbook from being viewed in a browser window.

Tip: If you cannot view a workbook in a browser window because it contains unsupported features, try opening the workbook in Excel on the desktop.
This feature
Works like this in a browser window
Controls
Controls, such as ActiveX controls and form toolbar controls, prevent a workbook from being viewed in a browser window.
Data connections
Depending on how your environment is configured, some kinds of data connections can prevent a workbook from being displayed in a browser window. For more information, see Refreshing data in a workbook in a browser window.
Data validation
Workbooks that use data validation can be edited in a browser window, but data validation cannot be set up in the browser.
Digital signatures
Workbooks that use visible or invisible digital signatures cannot be viewed in a browser window.
Fonts
Fonts are usually displayed using the same style and size in a browser as they are displayed in Excel. If a workbook uses a specific font that is not available on your device, then another font might be substituted when a workbook is displayed in a browser window.
Functions
Some kinds of functions can behave differently in a browser window than they do in Excel. For more information, see the Functions section later in this article.
Legacy macro languages
Workbooks that contain legacy macro features, such as Microsoft Excel 4.0 Macro Functions and Microsoft 5.0 dialog sheets cannot be displayed in a browser window.
Save
When you or other people edit a workbook in a browser window, changes are saved automatically.
Security and privacy
Workbooks that have Information Rights Management (IRM) settings applied at the workbook level cannot be viewed in a browser window.
If your organization is using Excel Web App (on premises) or Excel Online (in the cloud) to display workbooks, then workbooks that are saved in IRM-protected document libraries are supported and can be displayed in a browser window.
Workbooks that are sent as IRM-protected attachments in Outlook Web App are also supported and can be displayed in a browser window.
However, if your organization is using Excel Services in SharePoint Server (on premises) to display workbooks, workbooks in IRM-protected libraries are not supported, and must be opened in Excel.
IRM cannot be applied in the browser.
Undo and Redo
When a workbook is edited by more than one person at a time, the Undo and Redo commands are not available in a browser window as soon as another user makes a change.
Worksheet protection or workbook protection
Workbooks that are protected (encrypted with password protection) cannot be viewed in a browser window.
Protected worksheets (not entire workbooks) can be viewed in a browser window in Excel Online.
In an on-premises environment where you're using Excel Services or Excel Web App, protected worksheets cannot be viewed in a browser window.
To remove protection, open the workbook in the Excel on the desktop.
XML
XML maps, XML embedded smart tags, and XML expansion packs prevent a workbook from being viewed in a browser window.

Functions in Excel and in Excel Online

Some workbook functions behave differently in a browser window than they do in Excel. The following table summarizes how some functions work in Excel and in a workbook viewed in a browser window.

This function
Works like this in Excel
Works like this in Excel Online
CHAR
Returns a character specified by a number. For non-printing characters, returns a block character.
Returns a character specified by a number. For non-printing characters, returns blank values.
HYPERLINK
Returns an active link that you can click and follow
Depending on the Workbook Interactivity and Workbook Navigation settings that are specified for a workbook, the HYPERLINK function can return an active link or an inactive link text string.
INFO
Returns the path of the current directory or folder on the computer.
Returns a #VALUE! error.
NOW
Returns the date and time on your computer
Returns the date and time on the server
RAND, RANDBETWEEN
Returns a random number each time it is used
Returns a random number each time it is used
RTD (real-time data)
Returns real-time data from a program that supports COM automation.
If values that have been returned by an RTD function are stored in a workbook, those values are displayed. If no values are stored in the workbook, a #N/A error is returned.
TODAY
Returns the date on your computer
Returns the date on the server

About Excel Online, Excel Web App (on premises) and Excel Services (on premises)

Different applications can be used to display a workbook in a browser window. Depending on how your environment is configured, you could be using Excel Online (part of Office Online), Excel Web App (part of Office Web Apps on premises), or Excel Services in SharePoint Server (on premises) to view a workbook in a browser window.

Excel Binary Workbook Vs Xlsx

An IT administrator makes this decision, and it can affect which capabilities are supported when viewing a workbook in a browser window. For more information, see the following resources:

A file with the XLSB file extension is an Excel Binary Workbook file. They store information in binary format instead of XML like with most other Excel files (like XLSX).
Since XLSB files are binary, they can be read from and written to much faster, making them extremely useful for very large spreadsheets. When dealing with big spreadsheets, you might also notice smaller file sizes when using XLSB vs XLSX.
XLSB files store spreadsheet data just like any other Excel workbook format. Workbooks can contain multiple worksheets, and within each worksheet is a collection of cells organized by rows and columns where text, images, charts, and formulas can exist.

How to Open an XLSB File

It's possible for an XLSB file to have macros embedded in it, which have the potential to store malicious code. It's important to take great care when opening executable file formats like this that you may have received via email or downloaded from websites you're not familiar with. See our List of Executable File Extensions for a listing of file extensions to avoid and why.
Microsoft Office Excel (version 2007 and newer) is the primary software program used to open XLSB files and edit XLSB files. If you have an earlier version of Excel, you can still open, edit, and save XLSB files with it, but you have to install the free Microsoft Office Compatibility Pack first.
If you don't have any versions of Microsoft Office, you can use OpenOffice Calc or LibreOffice Calc to open XLSB files.
Microsoft's free Excel Viewer lets you open and print XLSB files without needing Excel. Just keep in mind that you can't make any changes to the file and then save it back to the same format — you'll need the full Excel program for that.
XLSB files are stored using ZIP compression, so while you can use a free file zip/unzip utility to 'open' the file, doing so won't let you read or edit it like the programs from above can do.

How to Convert an XLSB File

If you have Microsoft Excel, OpenOffice Calc, or LibreOffice Calc, the easiest way to convert an XLSB file is to open the file in the program and then save it back to your computer in another format. Some file formats supported by these programs include XLSX, XLS, XLSM, CSV, PDF, and TXT.
In addition to supporting some of the file formats listed above, FileZigZag is another XLSB converter that can save the XLSB to XHTML, SXC, ODS, OTS, DIF, and many other formats. FileZigZag is an online file converter, so you have to first upload the XLSB file to the website before you can download the converted file.

XLSB Files and Macros

The XLSB format is similar to XLSM — both can embed and run macros if Excel has macro capabilities turned on.
However, an important thing to understand is that XLSM is a macro-specific file format. In other words, the 'M' at the end of the file extension indicates that the file may or may not contain macros, while it's non-macro counterpart XLSX can also have macros but is unable to run them.
XLSB, on the other hand, is much like XLSM in that it can be used to store and run macros, but there isn't a macro-free format like there is with XLSM.
All this really means is that it's not as easily understood whether or not a macro may exist in the XLSM format, so it's important to understand where the file came from to ensure that it isn't loading harmful macros.

More Help With XLSB Files

If your file won't open with the programs suggested above, the very first thing you should check is that the file extension for your file actually does read as '.XLSB' and not just something that looks similar. It's really easy to confuse other file formats with XLSB given that their extensions look alike.
For example, you might really be dealing with an XLB file which does not open in Excel or OpenOffice in the normal way like you'd expect an XLSB file to work. Follow that link to learn more about those files.
XSB files are similar in how their file extension is spelled, but they're really XACT Sound Bank files that have nothing to do with Excel or spreadsheets in general. Instead, these Microsoft XACT files reference sound files and describe when they should be played during a video game.
If you don't have an XLSB file and that's why it's not working with the programs mentioned on this page, then research the file extension you do have so that you can find out which program or website can open or convert your file.
Excel 2007/2010 offers an option to save my files in an 'Excel Binary Workbook' format that seems to be smaller (50% of the size in some cases) and load more quickly. Is there a downside to this format? Should I be avoiding it for some reason?
I'm thinking there has to be some shortcoming to it, or it would be the default save format instead of XLSX, but I can't figure out what the faults might be. XLSX seems to be reasonably common in other products that can import Excel files, but none of them support XLSB - why not?
SqlRyanSqlRyan
7414 gold badges14 silver badges24 bronze badges

closed as primarily opinion-based by random♦Feb 27 '14 at 23:52

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise. If this question can be reworded to fit the rules in the help center, please edit the question.

4 Answers

As stated, xlsb is a binary file type, and saves in binary format. All other xls file types save in open XML format. We're not here to talk about advantages, but disadvantages.
  1. The only real disadvantage is going to be compatibility in using the data with software that wants XML instead of binary (web server for instance). If you link a lot of systems together, this may cause a problem with one of the layers, as XML was developed specifically for this purpose.
  2. Overall, there are no other disadvantages other than the fact that you might not be able to tell if there are macros in it or not as there is no macro-free version of this format. You can just change your macro settings to disable with prompt and examine visual basic to determine if there are harmful macros.
A compelling list to use xlsb as your default file format.
Excel Binary Workbook Vs Xlsx
RaystafarianRaystafarian
19.6k10 gold badges51 silver badges89 bronze badges
Mac iWork Numbers, Quickview, iOS preview and iOS Numbers do not recognise xlsb files.
epoonepoon
Saving in binary allows formulas to be saved properly if they are longer than the 8192 character limit.
ShaneShane
I don't use the xlsb format for two reasons.
  1. Because the file has all of the XML plus the binary, the file is larger than the corresponding xlsx or xlsm file.
  2. When I was working with a large and complex file, the binary would get corrupted frequently and I would have to restore from a back up copy of the file.
Update: I tried the xlsb format when it first came out and had the above problems. Problem 1 doesn't happen with Excel 2010 so maybe problem 2 is fixed also.
On the other hand, even if all of the above is fixed, I still won't use xlsb very often because most of my Excel files are actually VBA projects. Tracking a binary in a code repository will bloat the repository pretty quickly. (I use Mercurial for my code repository and, with the zipdoc extension turned on, I can tell it that xlsx AND xlsm files are zipped XML text files instead of binary.)
mischab1mischab1

Not the answer you're looking for? Browse other questions tagged microsoft-excel or ask your own question.

Most of the time, you’ll probably want to save your workbooks in the current file format (.xlsx). But sometimes, you might need to save a workbook in another file format, like the file format of an earlier version of Excel, a text file, or a PDF or XPS file. Just keep in mind that whenever you save a workbook in another file format, some of its formatting, data, and features might not be saved.

Newer versionsOffice 2010Office 2007
For a list of file formats (also called file types) you can (and can’t) open or save in Excel 2013, see File formats that are supported in Excel at the end of this article.
  1. Open the workbook you want to save.
  2. Click File > Save As.
  3. Under Places, pick the place where you want to save the workbook. For example, pick OneDrive to save it to your Web location or Computer to save it in a local folder like your Documents.
  4. In the Save As dialog box, navigate to the location you want.
  5. In the Save as type list, click the file format you want. Click the arrows to scroll to file formats that aren’t visible in the list.
    Note: The file formats you’ll see vary, depending on what type of sheet is active in your workbook (a worksheet, chart sheet, or other type of sheet).
  6. In the File name box, accept the suggested name or type a new name for the workbook.

Convert an Excel 97-2003 workbook to the current file format

Excel Workbook Examples

If you opened an Excel 97-2003 workbook but don’t need to keep it in that file format, simply convert it to the current file format (.xlsx).
  1. Click File > Info.
  2. Click Convert.

File formats that are supported in Excel

In Excel 2013, you can open and save files in the following file formats:
Excel file formats
Format
Extension
Description
Excel Workbook
.xlsx
The default XML-based file format for Excel 2007-2013. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm).
Strict Open XML Spreadsheet
.xlsx
An ISO strict version of the Excel Workbook file format (.xlsx).
Excel Workbook (code)
.xlsm
The XML-based and macro-enabled file format for Excel 2007-2013. Stores VBA macro code or Excel 4.0 macro sheets (.xlm).
Excel Binary Workbook
.xlsb
The binary file format (BIFF12) for Excel 2007-2013.
Template
.xltx
The default file format for an Excel template for Excel 2007-2013. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm).
Template (code)
.xltm
The macro-enabled file format for an Excel template in Excel 2007-2013. Stores VBA macro code or Excel 4.0 macro sheets (.xlm).
Excel 97- Excel 2003 Workbook
.xls
The Excel 97 - Excel 2003 Binary file format (BIFF8).
Excel 97- Excel 2003 Template
.xlt
The Excel 97 - Excel 2003 Binary file format (BIFF8) for an Excel template.
Microsoft Excel 5.0/95 Workbook
.xls
The Excel 5.0/95 Binary file format (BIFF5).
XML Spreadsheet 2003
.xml
XML Spreadsheet 2003 file format (XMLSS).
XML Data
.xml
XML Data format.
Excel Add-In
.xlam
The XML-based and macro-enabled Add-In format for Excel 2007-2013. An Add-In is a supplemental program that is designed to run additional code. Supports the use of VBA projects and Excel 4.0 macro sheets (.xlm).
Excel 97-2003 Add-In
.xla
The Excel 97-2003 Add-In, a supplemental program that is designed to run additional code. Supports the use of VBA projects.
Excel 4.0 Workbook
.xlw
An Excel 4.0 file format that saves only worksheets, chart sheets, and macro sheets. You can open a workbook in this file format in Excel 2013, but you cannot save an Excel file to this file format.
Text file formats
Format
Extension
Description
Formatted Text (Space-delimited)
.prn
Lotus space-delimited format. Saves only the active sheet.
Text (Tab-delimited)
.txt
Saves a workbook as a tab-delimited text file for use on another Microsoft Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
Text (Macintosh)
.txt
Saves a workbook as a tab-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
Text (MS-DOS)
.txt
Saves a workbook as a tab-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
Unicode Text
.txt
Saves a workbook as Unicode text, a character encoding standard that was developed by the Unicode Consortium.
CSV (comma delimited)
.csv
Saves a workbook as a comma-delimited text file for use on another Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
CSV (Macintosh)
.csv
Saves a workbook as a comma-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
CSV (MS-DOS)
.csv
Saves a workbook as a comma-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.
DIF
.dif
Data Interchange Format. Saves only the active sheet.
SYLK
.slk
Symbolic Link Format. Saves only the active sheet.
Note: If you save a workbook in any text format, all formatting is lost.
Other file formats
Format
Extension
Description
DBF 3, DBF 4
.dbf
dBase III and IV. You can open these files formats in Excel, but you cannot save an Excel file to dBase format.
OpenDocument Spreadsheet
.ods
OpenDocument Spreadsheet. You can save Excel 2010 files so they can be opened in spreadsheet applications that use the OpenDocument Spreadsheet format, such as Google Docs and OpenOffice.org Calc. You can also open spreadsheets in the .ods format in Excel 2010. Formatting might be lost when saving and opening .ods files.
PDF
.pdf
Portable Document Format (PDF). This file format preserves document formatting and enables file sharing. When the PDF format file is viewed online or printed, it retains the format that you intended. Data in the file cannot be easily changed. The PDF format is also useful for documents that will be reproduced by using commercial printing methods.
XPS Document
.xps
XML Paper Specification (XPS). This file format preserves document formatting and enables file sharing. When the XPS file is viewed online or printed, it retains exactly the format that you intended, and the data in the file cannot be easily changed.
File formats that use the clipboard
If you copied data to the clipboard in one of the following file formats, you can paste it into Excel using the Paste or Paste Special command (Home > Clipboard > Paste).
Format
Extension
Clipboard type identifiers
Picture
.wmf or .emf
Pictures in Windows Metafile Format (WMF) or Windows Enhanced Metafile Format (EMF).
Note: If you copy a Windows metafile picture from another program, Excel pastes the picture as an enhanced metafile.
Bitmap
.bmp
Pictures stored in Bitmap format (BMP).
Microsoft Excel file formats
.xls
Binary file formats for Excel versions 5.0/95 (BIFF5), Excel 97-2003 (BIFF8), and Excel 2013 (BIFF12).
SYLK
.slk
Symbolic Link Format.
DIF
.dif
Data Interchange Format.
Text (tab-delimited)
.txt
Tab-separated text format.
CSV (Comma-delimited)
.csv
Comma-separated values format.
Formatted text (Space-delimited)
.rtf
Rich Text Format (RTF). Only from Excel.
Embedded object
.gif, .jpg, .doc, .xls, or .bmp
Microsoft Excel objects, objects from properly registered programs that support OLE 2.0 (OwnerLink), and Picture or another presentation format.
Linked object
.gif, .jpg, .doc, .xls, or .bmp
OwnerLink, ObjectLink, Link, Picture, or other format.
Office drawing object
.emf
Office drawing object format or Picture (Windows enhanced metafile format, EMF).
Text
.txt
Display Text, OEM Text.
Single File Web Page
.mht, .mhtml
Single File Web Page (MHT or MHTML). This file format integrates inline graphics, applets, linked documents, and other supporting items referenced in the document.
Web Page
.htm, .html
Hypertext Markup Language (HTML).
Note: When you copy text from another program, Excel pastes the text in HTML format, regardless of the format of the original text.
File formats that are not supported in Excel 2013
The following file formats are no longer supported, so you can’t open or save files in these file formats.
Save
To work with your workbook data in a program that isn’t supported anymore, try the following:
Format
Extension
Clipboard type identifiers
Excel Chart
.xlc
Excel 2.0, 3.0, and 2.x file formats
WK1, FMT, WK2, WK3, FM3, WK4
.wk1, .wk2, .wk3, .wk4, .wks
Lotus 1-2-3 file formats (all versions)
Microsoft Works
.wks
Microsoft Works file format (all versions)
DBF 2
.dbf
DBASE II file format
WQ1
.wq1
Quattro Pro for MS-DOS file format
WB1, WB3
.wb1, .wb3
Quattro Pro 5.0 and 7.0 for Windows.
You can save an Excel 2007 or later workbook in the file format of an earlier version of Excel, in a text file format, and in other file formats, such as PDF or XPS. By default, files are saved in the .xlsx file format, but you can change the default file format for saving. If you frequently use the Save As command, you may want to add it to the Quick Access Toolbar.

Save an Excel workbook in a different file format

Important: If you save a workbook in a file format other than the current Excel file format, formats and features that are unique to Excel 2007 and later will not be retained. For more information, see Use Excel with earlier versions of Excel.
  1. In Excel, open the workbook that you want to save for use in another program.
  2. On the File tab, click Save As.
  3. To save the workbook to a different location, specify the drive and location in the file path and folder boxes.
  4. In the File name box, accept the suggested name or type a new name for the workbook.
  5. In the Save as type list, click the format that you know you can open in the other program.
If needed, click the arrows to scroll to file formats that are not visible in the list.
Note: The file formats that are available vary, depending on what type of sheet is active (a worksheet, chart sheet, or other type of sheet).
Tip: For more information on how to save a workbook in PDF (.pdf) or XPS (.xps) file formats, see Save as PDF or XPS.

Save a different file format in an Excel 2007 and later file format

You can save any file format that you can open in Excel 2007 and later in the current Excel Workbook file format (.xlsx). By doing this, you can use new features that are not supported by other file formats.
Note: When you save a workbook that was created in an earlier version of Excel as an Excel 2007 and later workbook, some formats and features may not be retained. For information on unsupported Excel 97-2003 features, see Use Excel with earlier versions of Excel.
  1. Open the file that you want to save in the current file format.
  2. On the File tab, click Save As.
  3. To save the file to a different location, specify the drive and location in the file path and folder boxes.
  4. In the File name box, accept the suggested name or type a new name for the workbook.
  5. In the Save as type list, do one of the following:
  6. Click Save.

Change the default file format for saving

You can change the file type that is used by default when you save a workbook.
  1. On the File tab, click Options.
  2. In the Save category, under Save workbooks, in the Save files in this format box, click the file format that you want to use by default.

Add the Save As command to the Quick Access Toolbar

The Save As command is not available as a button on the ribbon. You can, however, add the command to the Quick Access Toolbar.
  1. Click the dropdown arrow on the Quick Access Toolbar, and then click More Commands.
  2. In the Choose commands from box, make sure that Popular Commands is selected.
  3. In the list box, scroll to the Save As button, and then select it.
  4. Click Add.
You can save a Microsoft Office Excel 2007 workbook in a different file format. You can save a workbook in an earlier version file format, in text file format, and in other file formats, such as PDF or XPS. You can also save any file format that you can open in Office Excel 2007 as an Excel 2007 workbook. By default, Excel 2007 saves files in the .xlsx file format, but you can change the default file format for saving.
If you frequently use the Save As command, you may want to add it to the Quick Access Toolbar.

Save a file in the Excel 2007 file format

You can save any file format that you can open in Excel 2007 in the current Excel Workbook file format (.xlsx). By doing this, you can use the new features of Excel 2007, such as the larger grid, that are not supported by other file formats.
Note: When you save a workbook that was created in an earlier version of Excel as an Excel 2007 workbook, some formats and features may not be retained.
  1. Open the workbook that you want to save as an Excel 2007 workbook.
  2. Click the Microsoft Office Button , and then click Save As.
  3. In the File name box, accept the suggested name or type a new name for the workbook.
  4. In the Save as type list, do one of the following:
  5. Click Save.

Change the default file format for saving

You can change the file type that is used by default when you save a workbook.
  1. Click the Microsoft Office Button , and then click Excel Options.
  2. In the Save category, under Save workbooks, in the Save files in this format box, click the file format that you want to use by default.

Add the Save As command to the Quick Access Toolbar

The Save As command is not available as a button on the Microsoft Office Fluent user interface Ribbon. You can, however, add the command to the Quick Access Toolbar.
  1. Click the Microsoft Office Button .
  2. Right-click Save As, and then click Add to Quick Access Toolbar.