print all or selected parts of a spreadsheet

Print an Excel table

If the data that you want to print is in a Microsoft Office Excel table, you can print just the Excel table.

1. Click a cell within the table to activate the table.
2. Click Microsoft Office Button , and then click Print.

   Keyboard shortcut You can also press CTRL+P.

3. Under Print what, click Table.

Define or clear a print area on a worksheet
If you print a specific selection on the worksheet frequently, you can define a print area (print area: One or more ranges of cells that you designate to print when you don't want to print the entire worksheet. If a worksheet includes a print area, only the print area is printed.) that includes just that selection. When you print the worksheet after defining a print area, only the print area will print. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet again.

Set a print area

1. On the worksheet, select the cells that you want to define as the print area.
2. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

Note The print area that you set is saved when you save the workbook.

Add cells to an existing print area

1. On the worksheet, select the cells that you want to add to the existing print area.
2. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Add to Print Area.

Clear a print area

1. Click anywhere on the worksheet for which you want to clear the print area.
2. On the Page Layout tab, in the Page Setup group, click Clear Print Area.