You can print an Excel workbook from the browser in two ways:
- By using the Print command in Internet Explorer
- By opening the workbook in Excel, and using the Print features there
Note This information applies only to an Excel workbook in a SharePoint environment. If you are using Excel Web App in OneDrive, see Print a spreadsheet in Excel Web App.
What do you want to do?
Print by using the Internet Explorer Print command
When you use the print features in Internet Explorer features, you can print only the information that appears on the screen. This print option does not include data that out of view, worksheets that are not currently displayed or named items that are not currently.
To print a page
- On the Internet Explorer command bar, click the Print button.
To preview how a page will look when it is printed
- Click the arrow to the right of the Print button, and then click Print Preview.
To change how a page appears on the printed page
- Click the arrow to the right of the Print button, and then click Page Setup.
- Change the print settings that you want, such as Portrait or Landscape orientation, print size, margins, etc.
- When you finish changing the print settings, click OK.
- Click the Print button.
Top of Page
Print by opening the workbook and using the Print features in Excel
Office Excel 2007 and Excel 2010 offer many options and features for printing a workbook, such as printing a selected range of cells, changing print settings and print layout, or printing the complete workbook. When you open a workbook in Excel, you can use all these options.
To print a workbook by opening it in Excel, you must have Office Excel 2007 or Excel 2010 installed on your computer.
Top of Page