Excel 2010 provides templates, ready-made worksheets for common uses. These predesigned templates contain standard or boilerplate text, but you can modify them to fit your needs. You can use the templates automatically installed with Excel 2010 or you can download free templates from Office.com, the Microsoft Office Web site. Excel templates use the .xltx filename extension, as opposed to .xlsx for an Excel workbook.
The following templates are automatically installed when you start using Excel 2010: Billing Statement, Blood Pressure Tracker, Expense Report, Loan Amortization, Personal Monthly Budget, Sales Report, and Time Card. Many additional templates are available for downloading.
Using the installed templates
5 product ratings - Microsoft Office 2010 Home Business Software Word Excel OneNote New Sealed /5X2 $99.95 Trending at $174.11 Trending price is based on prices over last 90 days. Microsoft Office 2010 Professional Full for 2 PC's $ 39.99. CODE: Minimum quantity. - Excel 2010 - Access 2010 - PowerPoint 2010 - InfoPath 2010. This is full Genuine MS Office 2010 Professional for 2 computers Microsoft Office 2010 Pro Plus (download link will be provided).
Follow these steps to use one of the templates that comes installed with Excel 2010:
- Click the File tab and then click New.The Available Templates panel appears in the Excel Backstage view.
- Click Sample Templates at the top of the Available Templates panel.The middle pane displays thumbnails for each of the installed templates. A preview of the selected thumbnail appears in a preview pane on the right.You can select an installed template to generate a new workbook.
- Select the desired template from the middle pane and click Create.Excel opens the selected template.A new billing statement worksheet generated from the Billing Statement template.
- Customize the template as needed.
- Save the file with a new name.
Downloading templates
If you have Internet access, you can easily view and download any of the templates offered by Microsoft directly from the Backstage view in Excel.
Follow these steps to download a template from the Office.com site:
- Click the File tab and then click New.
- Click the category of the template you want to download under Office.com Templates.The middle pane displays thumbnails for each of the items in that category. In some cases, you may need to select a subcategory in the middle pane before you see the thumbnails. A larger preview of the selected thumbnail appears in a preview pane on the right.Selecting a Budget template to download from Office.com.
- Select the thumbnail image for the template you want to download and then click the Download button.The Download button appears under the template’s preview, on the right side of the Available Templates panel.
- Customize the template as needed.
- Save the file with a new name.
After downloading a template from Office.com, you can use the template to generate new workbooks by opening it from the Personal Templates tab of the New dialog box (open this dialog box by clicking the My Templates button in the Available Templates panel in the Excel Backstage view).
-->Notice
Excel Viewer has been retired
Important
The Microsoft Excel Viewer was retired in April, 2018. It is no longer available for download or receive security updates. To continue viewing Excel files for free, we recommend installing the Excel mobile app or storing documents in OneDrive or Dropbox, where Excel Online opens them in your browser. For the Excel mobile app, visit the store for your device:
Summary
The Microsoft Excel Viewer is a small, freely redistributable program that lets you view and print Microsoft Excel spreadsheets if you don’t have Excel installed. In addition, the Excel Viewer can open workbooks that were created in Microsoft Excel for the Macintosh.
The Excel Viewer can open the latest version of Excel workbooks, but it will not display newer features.
More Information
The Microsoft Excel Viewer is the latest version of the viewer. It can read the file formats of all versions of Excel, and it replaces the Microsoft Excel Viewer 2003.
Other options for free viewing of Excel workbooks
- Excel Online Excel Online is available through OneDrive or deployed as part of Microsoft SharePoint. Excel Online can view, edit and print Excel workbooks. For more information about Excel Online, see the Office Online overview.
- Office 365 Trial Downloading the trial will give you access to the full capabilities of Microsoft Office 2013. For more information, see Office 365 Home.
- Office Mobile applications Download the trial for mobile applications available on iPhone, Android phone, or Windows Phone. For more information, see Office on mobile devices.
Note
The Excel Viewer is available only as a 32-bit application. A 64-bit version of the Excel Viewer does not exist. The 32-bit version of the Excel Viewer can be used on 64-bit versions of Windows.
The file name of the Excel Viewer is xlview.exe. The default folder location for the Excel Viewer on a 32-bit operating system isc:Program FilesMicrosoft OfficeOffice12. The default folder location for the Excel Viewer on a 64-bit operating system is c:Program Files (x86)Microsoft OfficeOffice12.
Note
If you already have a full version of Microsoft Excel installed on your computer, do not install Microsoft Excel Viewer in the same directory. Doing this causes file conflicts.
File formats supported
The Excel file formats supported are .xlsx, .xlsm, .xlsb, .xltx, .xltm, .xls, .xlt, .xlm, and .xlw. Macro-enabled files can be opened (.xlsm, .xltm, and .xlm), but the macros do not run.
Known issues with newer versions of Excel workbooks and the Excel Viewer
Even though the Excel Viewer can read the latest Excel workbooks, the following new features are not visible or are displayed differently in the Excel Viewer.
- Sparklines are not shown in the Excel Viewer. The cells where they are located are blank.
- PivotTables and PivotCharts are flattened. The data or chart will appear, but modifications cannot be made.
- Macros do not run in the Excel Viewer.
- Slicers do not display data in the Excel Viewer. Instead, a box is displayed in the location of the slicer and it contains the following text: 'This shape represents a slicer. Slicers are supported in Excel 2010 or later. If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2003 or earlier, the slicer cannot be used.'
If you have to view or use these features, use Excel Online.