![quick print excel quick print excel](https://i0.wp.com/www.learningcomputer.com/images/excel_page_layout_tab2bb.jpg)
He had just spent the entire morning repeating the same page setup choices for each of the worksheets in a large Excel workbook.
QUICK PRINT EXCEL MANUAL
Important Note: with Scaling other than 100%, manual page breaks are ignored.Ī few years ago, I was heading down the hall at a client's building when one of the managers pulled me into his office. This setting won't stretch pages to 999 pages but will make sure that a low value won't accidentally shrink the pages to a much smaller size.Īnother option under Scaling is to adjust the size to a percentage of the normal size. For instance, if you want to fit all data columns on one lengthwise page, change orientation to landscape and choose Fit to 1 page wide by 999 pages tall. Next, select the Page tab and under the Scaling category pick Fit to.Change paper size and orientation if you want. First choose File > Page Setup, set margins to the smallest size that will work for your layout.A worksheet can be split into as many pages as needed to display the content but sometimes you might want to fit all data into one page by height or width. Unlike Word documents, content is not limited by the paper size or orientation. Finally, click into the actual spreadsheet and highlight the row(s) and/or column(s) that you want to see on every page. Under the Print Titles option, choose Rows to repeat at top and/or Columns to repeat at left. All you need to do is pick File > Page Setup and choose the Sheet tab. Print Headings on Every Page Do you want to print the same rows or columns on every page? Printing headings is easy with Print Titles. Select the row or column where you want to create a new worksheet page the break will appear above the highlighted row or to the left of the selected column. Here's another way to control page breaks. To change back to the previous view, pick View > Normal. I usually change the Zoom (found on the right side of the Standard toolbar) to 100%. You can perform all worksheet actions from the Page Break Preview. This view is also a handy way to see how your worksheet breaks out into pages notice the gray page labels such as in this view. The dashed lines show where page breaks will occur these can be moved to adjust and create manual page breaks which display as solid blue lines. The visible white area in the Page Break Preview is the print area which can be adjusted by moving the solid blue boundary lines. (This option is also available from the Print Preview view). Most Excel users have yet to discover the Page Break Preview, another great way to setup the print area in a worksheet.
![quick print excel quick print excel](https://i.pinimg.com/originals/6c/5a/c2/6c5ac2950d8d9b1506e1ef158acc674e.png)
Under the category, Print What (bottom-left corner), pick Selection and choose OK. If you only need to temporarily print a range of cells, just highlight the range and choose File > Print.