Viewing your worksheet for printing
Preparing to print
Excel provides many optional settings so you can adjust the appearance of the printed page. To make sure you've checked everything likely to affect your printout, do the following:
Change the format and layout of the worksheet on-screen
You can set the orientation of the printed worksheet to portrait or landscape.
When to use landscape Switch to landscape when you need to print many more columns of data than will fit on a portrait page. If you don't want to use landscape, you can change the layout of the printed worksheet to fit the data to the available space, or adjust the margins.
Making the data fit the page You can make the printed image fit the page or paper size by shrinking or expanding the image. Other changes you can make to the layout of the printed worksheet include setting the paper size, centering the data on the printed page, and controlling how the pages are numbered. These changes affect only the worksheet's printed appearance, not how it looks on the screen.
Print partial data To print only selected parts of the data on a worksheet, you can specify which areas to print.
Add headers and footers
Preview and adjust margins
To see each page exactly as it will print, click Print Preview . In print preview, you can see headers, footers, and print titles (print titles: Row or column labels that are printed at the top of or on the left side of every page on a printed worksheet.).
When to adjust margins Adjust the margins or columns when your data is too wide to fit across the page and you don't want to shrink it to fit. In print preview, you can change the width of the margins and columns on the worksheet by dragging the sizing handles. Click the Margins button to display the handles.
Margin sizing handles
Column sizing handles
Change the size of individual columns and rows Move the gridlines in the row numbers and column letters areas.
Gridlines, page order, and other settings In print preview, you can change the way your worksheet prints. With the Setup button, you can turn gridlines on or off, print a draft copy of your worksheet, and change the order in which pages are printed.
Check page breaks
Repeat titles on every page
Repeat row and column labels If the data on your worksheet has column or row labels (also called print titles), you can have Excel repeat these labels on every page of the printed worksheet.
The labels don't have to be in the first rows or columns of the worksheet, but they don't begin repeating until after the row or column they originally appeared in has been printed.
Repeat row and column headings You can also print the row numbers or column letters for a worksheet (don't confuse these headings with the labels in your data).
You can use any combination of headers and footers, repeating labels, and row and column headings.
Previewing specific sheets or pages
Range of pages You can preview a specific range of pages.
Embedded chart If a worksheet contains an embedded chart, print preview displays both the worksheet and the chart. You can move or resize the chart in normal view or page break preview. If you select an embedded chart before you click Print Preview , Excel displays only the embedded chart.
Page number and total pages The status bar at the bottom of the screen shows the current page number and the total number of pages to be printed.
Speeding up a printing job
Printing a draft You can speed up the time it takes to print a worksheet by temporarily changing the print quality. If you know the printer resolution you want to use, you can change the print quality for the printer. If you are unsure of the resolution (or quality), you can print the document in draft quality, which increases printing speed by ignoring formatting and most graphics.
Printing in black and white On black-and-white printers, Excel prints colors as gray shades. You can reduce the amount of time it takes Excel to print a worksheet that contains colors by printing colors in black and white. When you print a worksheet by using only black and white, Excel prints fonts and borders formatted in color as black, not as gray shades. Excel also prints cell and AutoShape backgrounds as white and prints other graphics and charts in shades of gray.
Printing without gridlines Large worksheets print faster if gridlines are not printed.
Using the Report Manager Add-in
Printing to fit a paper width or a certain number of pages
If your work doesn't fit exactly on the number of printed pages you want, you can adjust, or scale, your printed work to fit on more or fewer pages than it would at normal size. You can also specify that you want to print your work on a certain number of pages.