Print in Excel 2016 2013 2010 2007 2003

Print comments

If your spreadsheet contains notes or comments, you can print them as they appear on the sheet or at the end of the sheet.

Three different ways for printing a selected area

Excel provides three easy ways to print chosen ranges: print the selection, define the print area in the Page Setup dialog, or create the print area. The first two methods work well for occasional printing but, if you need to print a specific range or ranges of worksheet frequently, defining one or multiple areas to print, significantly reduce the efforts. Moreover, with print areas, you can easily add new ranges to the current selection.

Print column headers or spreadsheet labels on every page

If you want to print a spreadsheet with data on several pages, it is more informative to have column headers or labels on every printed page. See also how to print a large Excel spreadsheet.

How to print a large Excel spreadsheet

Microsoft Excel proposes some unique features that can help to work fast and easy with a lot of data. One of the important things of working with large worksheets is the possibility to switch between presentations of results only and all intermediate data.

Adding and removing page breaks

On the printing spreadsheet, you might not be satisfied with the current pagination, so you might need to insert or remove manual a page break.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more