Pivot Tables are something you’ll learn to make and edit in our other videos specific to that topic, but suffice to say they’re a great tool for displaying data from various perspectives, for easier analysis. Now, back on the Home tab, let’s switch to a more demanding worksheet – this sheet has a large Pivot Table on it. I can also adjust the Scaling to fully utilize the width of the page. To quickly make all of this worksheet fit on one page, all I have to do is drag the dashed line to the far left (note my 2-headed mouse pointer as I point to that dashed line), telling Excel to make all of the columns fit on one page.Ī quick switch to the Print Preview on the File tab shows me more clearly how my changes will affect the printout of my worksheet, and I can make one change here – switching to Landscape orientation to let the columns spread out over a larger area horizontally. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |