How to Print a Large Excel Spreadsheet

Techwalla may earn compensation through affiliate links in this story.
Printing a spreadsheet without reformatting it may make it unreadable.

Spreadsheets are generated with hundreds of cells, making them literally unfillable, with the only real restraint being the amount of available memory in your computer. While this means you can fit all the data you need into the spreadsheet, it can make them difficult to print, as they can become very large. Luckily, there is a way to print the spreadsheet so that it remains correctly formatted.


Step 1

Set the print area by selecting the top left corner of the area you wish to print, and dragging to the bottom right. This will create an outline around the area you wish to print. Click "File," "Print Area" and "Set Print Area."

Video of the Day

Step 2

Click "File" and "Print Preview."


Step 3

Set the page size to the paper you will be using. The standard is A4.

Step 4

Set the scaling. Try checking "Fit to one page(s) wide by one page(s) tall" box. If the percentage showed in the toolbar changes to below 40 percent, the text will probably be too small to read. If not, click on the page to view a print preview and check if the spreadsheet is big enough to be understood. Choose a bigger percentage if not.



Step 5

Reset the margins. You may need to click the "Margins" icon in the toolbar to show the margins if they do not show up automatically. Drag along the margin to shrink it, and create more usable space.

Step 6

Click "Print."



Report an Issue

screenshot of the current page

Screenshot loading...