1. Save a workbook in another file format - Microsoft Support
If you want to save the workbook as a template, click Excel Template (*.xltx). If you are saving a workbook that was created in an earlier version of Excel ...
Lists file formats (file types) that are supported in Excel, their extensions, and how to save workbooks to a different format or the current XML-based format (.xlsx).
2. Use Excel with earlier versions of Excel - Microsoft Support
To work in the current file format, click Yes to close and reopen the workbook. Save the workbook in the current file format If you want to keep a copy of ...
After you have installed a new version of Excel, you may want to know how you can continue to work with workbooks that are created in an earlier version of Excel, how you can keep these workbooks accessible for users who do not have the current version of Excel installed, and how the differences between the versions affect the way that you work.
3. An error occurred when sending commands to the program in Excel
Jul 21, 2022 · To correct this setting, follow these steps: Select File > Options. Select Advanced, scroll down to the General section, and then clear the ...
Discusses that you receive an An error occurred when sending commands to the program error message when you try to open an Excel workbook by double-clicking its icon or file name. Provides multiple resolutions.
4. Excel formatting and features that are not transferred to other file formats
This file format (.prn) saves only the text and values as they are displayed in cells of the active worksheet. If a row of cells contains more than 240 ...
The .xlsx workbook format introduced in Excel 2007 preserves all worksheet and chart data, formatting, and other features available in earlier Excel versions, and the Macro-Enabled Workbook format (.xlsm) preserves macros and macro sheets in addition to those features. If you frequently share workbook data with people who use an earlier version of Excel, you can work in Compatibility Mode to prevent the loss of data and fidelity when the workbook is opened in the earlier version of Excel, or you can use converters that help you transition the data.
5. Refresh an external data connection in Excel - Microsoft Support
To keep imported external data up-to-date, you can refresh it to see recent updates and deletes. Excel provides many options for refreshing data, ...
You can connect your Excel workbook to an external data source, such as a SQL Server database, an OLAP cube, or even another Excel workbook. This connection can appear in your workbook as a table, PivotTable report, or PivotChart. You can keep the data in your workbook up to date by refreshing the link to its source. Each time you refresh the connection, you see the most recent data, including anything that's new or has been deleted.
6. Export to Excel from SharePoint or Lists - Microsoft Support
Excel workbook The data has a one-way connection to the original list. Periodically refreshing the workbook pulls in changes that have been made in the list.
Learn how to use the Export to Excel command in SharePoint
7. Import contacts from an Excel spreadsheet to Outlook
Click Yes to have Excel save the current worksheet as a CSV file. The original workbook (the .xlsx file) closes. Close the CSV file. You're done with Excel.
Learn how to import your contacts from an Excel spreadsheet to Outlook.
8. Advanced options - Microsoft Support
... box, and then type the separator that you want to use. Cut, Copy, and Paste. Show Paste Options buttons Select to have Excel automatically display a dialog box ...
Discover the meaning of each of Excel's advanced options.
9. Video: Add formulas and references - Microsoft Support
Posted: Jul 6, 2017
Training: Formulas help you extract useful information from your data. Add cell references and functions to calculate values that update automatically when you change your data.
10. Video: Save and print an Excel workbook - Microsoft Support
Missing: pull- | Show results with:pull-
Training: Save your workbook so you don't lose all your hard work, then print it to share it with others.
11. Video: Create a PivotTable manually - Microsoft Support
Posted: Jun 2, 2020
Training: Create a manual PivotTable if you prefer to design the PivotTable yourself. Here's how.
12. Release notes for Semi-Annual Enterprise Channel (Preview)
Sep 12, 2023 · Reducing slowness and freezes when multiple workbooks are open: This feature reduces slowness and freezes experienced when working in a workbook ...
Provides IT Pros with release notes for Semi-Annual Channel (Targeted) releases for Microsoft 365 Apps
13. Organize your ideas with Collections in Microsoft Edge
... saved, so you can always get back to what you were working on. On an iOS ... Select a card and drag it up or down in the list to move it. On an iOS device. At ...
Learn how to use Collections to save images, text, and webpages in Microsoft Edge.
14. Overview of forms, Form controls, and ActiveX controls on a worksheet
Each label has an adjacent blank text box in which you can enter data for each column, up to a maximum of 32 columns. In a data form, you can enter new rows, ...
Create, edit, format, lock, and unlock Excel forms, including data forms, worksheets that contain Form and ActiveX controls, and VBA UserForms.
15. Import or export text (.txt or .csv) files - Microsoft Support
To export data from Excel to a text file, use the Save As command and change the file type from the drop-down menu. There are two commonly used text file ...
To import a text file, you can open the file or import the text file as an external data range. To export a text file, use the Save As command.
16. Customize the save experience in Office - Microsoft Support
... your local device, continue using the new dialog with a default local location. From the location dropdown, you can set any recent location as your default ...
How to change the name of the Documents folder you're saving to, or create a new working folder.
17. Save, back up, and recover a file in Microsoft Office
Saving a file to OneDrive or SharePoint allows you to access it on any device and enables features such as AutoSave and Version History, which can help prevent ...
Save a document to your local drive, or to the cloud in a choice of formats.
18. Differences between using a workbook in the browser and in Excel
Missing: pull- | Show results with:pull-
Learn which Excel features are supported in a browser window.
19. Video: Manage drop-down lists - Microsoft Support
Posted: Jun 4, 2020
Training: To prevent changes to your drop-down list data, you can hide the columns, rows, or the entire worksheet that contains the data. And unhide them if you need to make changes. You can also lock and password protect the cells on the worksheet or even the entire worksheet.