Printing in Excel doesn’t have to be problematic.
You’ve created a long or intricate Excel spreadsheet. And you’ve just sent it to your printer. But when you check the pages coming out of the printer, you see that the spreadsheet didn’t print right. Whatever went wrong, you can avoid many printing problems in Excel by following the right steps. You can ensure that your spreadsheet prints in the right orientation, takes up the right number of pages, and doesn’t get cut off at the wrong spots. Let’s check out how.
I’m using Excel 2016 for these steps, but the basic features and options for printing should be the same across the previous couple of versions. If you want to try this out on your end, launch Excel and create or open a large spreadsheet. If not, just follow along.
Set Paper Size and Orientation. Before you print, you should set up your page options. The first step is to confirm or change your paper size. Click on the Page Layout tab and click on the Paper Size button. You can choose Letter, Legal, and other sizes. Letter or legal are the most common choices in the US. But if you’re using a more unusual size and don’t see it listed, click on the More Paper Sizes command to view additional sizes.
Next, confirm the orientation. You typically print a spreadsheet in landscape mode to maximize the printing space. Click on the Orientation button and change it from Portrait to Landscape.