Printing in Excel

Set options before you print

• Did you know you can set page margins to align the worksheet data better on a printed page? Page margins are the blank spaces between the worksheet data and the edges of the printed page. See Set page margins before printing a worksheet.

• Does your worksheet have a lot of columns that you need to be accommodated on a single page or fixed number of pages? If so, you will have to scale your worksheet so that the data in your worksheet fits the dimensions of the page. Scaling can even help you switch to a different font size if the current font doesn't seem to work. See Scale a worksheet.

• Want to change the page orientation such as landscape or portrait? See Print a worksheet in landscape or portrait orientation.

• Need to adjust page breaks before printing? See Create manual page breaks in a worksheet .

• Did you know gridlines don't appear on a printed page? You will need to enable the setting if you want gridlines in your printed data. See Print gridlines in a worksheet.

• Did you know you can add headers and footers to the worksheet before printing? For example, page numbers, date, file name, or anything relevant. See Headers and footers in a worksheet.

• Do you want to print row or column headers on top of every page? It's also called print titles. See Print rows with column headers on top of every page.

• If you want a faster printing output, you can switch to a lower dots-per-inch (dpi) resolution or use draft quality printing. See Change the print resolution or print quality for a worksheet.

  : A lower dpi setting or draft quality printing will reduce printing time, but also result in a low print quality.

Preview

Preview pages before you print. See Preview worksheet pages before you print .

Print only part of a worksheet

A print area is one or more ranges of cells that you designate to print when you don't want to print the entire worksheet. If you print a specific selection on a worksheet frequently, you can define a print area that includes just that selection. See Change or clear a print area on a worksheet

Print a worksheet or workbook

You can print entire or partial worksheets and workbooks, one at a time, or several at once. And if the data that you want to print is in a Microsoft Excel table, you can print just the Excel table. You can also print to a file instead to a printer. See Print a worksheet or workbook

Troubleshoot printing issues

My Print button and some printer settings aren’t available