Excel print preview only shows one page
/en/excel2010/worksheet-basics/content/ Show IntroductionThere are many choices you can make when printing an Excel workbook. You can choose what parts of a workbook to print and how the data fits on the page. In this lesson, you will learn how to print worksheets, workbooks, and selections of cells. You will also learn how to prepare for printing by modifying page orientation, scale, margins, print titles, and page breaks. In previous versions of Excel, there was a Print Preview option that allowed you to preview and modify a workbook before printing. You may have noticed that this feature seems to be gone in Excel 2010. It actually has not disappeared; it has just been combined with the Print window to create the Print pane, which is located in Backstage view. Optional: You can download this example for extra practice. To view the Print pane:
Click the buttons in the interactive below to learn about the Print pane. Show Margins/Zoom to PageThe Zoom to Page button is on the right. Click it to zoom in and out in the Preview pane. The Show Margins button is to the left of the Zoom to Page button. Click it to adjust the margins of your workbook. PageClick the arrows to view a different page in the Print Preview area. Print PreviewThis allows you to see how your worksheets will look when printed. ScalingChoose how to scale your worksheets for the printed page. You can scale worksheets at their actual size, to fit all on one page, to fit all the columns on one page, or to fit all the rows on one page. MarginsYou can adjust the margins here. This is useful if parts of your worksheets are being cut off by the printer. Paper SizeChoose the paper size you want your printer to use. OrientationHere, you can choose portrait or landscape orientation. Collated/UncollatedIf you are printing multiple copies, choose whether you want the copies collated or uncollated. One Side/Both SidesChoose whether to print on one side or both sides of the paper. Print RangeChoose whether to print the active sheets, entire workbook, or a selection of cells. PrinterYou may need to select the printer you want to use if your computer is connected to multiple printers. Print ButtonClick the Print button when you are ready to print. To print active sheets:If you have multiple worksheets in your workbook, you'll need to decide if you want to print the entire workbook or specific worksheets. Excel gives you the option to Print Active Sheets. A worksheet is considered active if it is selected.
To print the entire workbook:
To print a selection or set the print area:Printing a selectionsometimes called setting the print arealets you choose which cells to print, as opposed to the entire worksheet.
You don't have to wait until you're ready to print to set the print area. You can also set it from the Page Layout tab in advance. This will place a dotted line around your selection so you can see which cells are going to print while you work. To do this, select the cells you want to print, go to the Page Layout tab, and choose Print Area. To change page orientation:Change the page orientation to portrait to orient the page vertically and landscape to orient the page horizontally. Portrait is useful for worksheets needing to fit more rows on one page, while landscape is useful for worksheets needing to fit more columns on one page.
To fit a worksheet on one page:
To modify margins while in Print Preview:The margins of your worksheet may need to be adjusted to make data fit more comfortably on the printed page. You can adjust the margins in Print Preview.
To use print titles:Imagine how difficult it would be to read a worksheet if the column and row headings only appeared on the first page. The Print Titles command allows you to select specific rows and columns to appear on each page.
To insert a break:
Challenge!
/en/excel2010/creating-complex-formulas/content/ |