How to print a large Excel spreadsheet

  • Excel
  • 2016
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 a 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 correctly several selected groups of columns. 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 .

Transactions Tracking

  • Income
  • Expense
  • Transfer
  • Buy,Sell and Dividend
Track your finances at https://moneybench.net Try Now

Quick Overview

  • Income and Expenses
  • Assets and Liabilities
  • Investments
  • Net worth
Track your finances at https://moneybench.net Try Now

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.