How to print a large Excel spreadsheet

Excel 365
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.

When you try to print spreadsheet with a lot of data, you can see not convenient or non-representative printings, for example:

Print preview on two pages in Excel 2016

Microsoft Excel proposes several different options for printing:

Print options in Excel 2016

Print all columns of the active spreadsheet

On the Print tab, in the Settings group, in the Scaling dropdown list, select Fit All Columns on One Page:

Fit All Columns on One Page in Excel 2016

Excel will print all columns of the spreadsheet on one page:

Print preview on One Page in Excel 2016

Print just some columns of the active spreadsheet

   1.   Select columns you want to print (unfortunately, Excel will not print several selected groups of columns correctly. So, hide columns you don't want to print first and select one continuous group of columns):

Selected data in Excel 2016

   2.   On the Print tab, in the Settings group, in the Print Area dropdown list, select Print Selection:

Print Selection in Excel 2016

Excel will print selected columns of the spreadsheet:

Print Selection preview in Excel 2016

See also Print column headers or spreadsheet labels on every page and Three different ways for printing a selected area.

See also this tip in French: Comment imprimer une grande feuille de calcul Excel.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

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