The watermarks and in gray also show you how many pages you’ll print out on. Here, as I switch to that view, you can see the same workbook, and the dashed line showing where that split, which puts the last 5 columns of the worksheet on page 2, occurs. As you can see here, my worksheet is too wide to fit entirely on a sheet of 8.5 x 11 paper, so it’ll take 2 sheets, and about half of the columns are going to end up on page 2.Īs I demonstrate in our video on Printing, you can use the various settings here in the Print view to change your paper size, reduce the margins, switch the orientation of the pages, even apply scaling to shrink your content to fit on the desired number of pages.Īnother way to (A) find out how your worksheet will print out and (B) make changes to how the content spreads out over one or more sheets of paper is to work in Page Break Preview, one of your view options on the View tab. When you go to print one of your worksheets – or even an entire workbook – it’s the Print preview through the File tab’s Print command that tells you how your data will lay out on the pages.

Print selection in excel