Print a sheet or workbook

You can print entire or partial sheets and entire workbooks, one at a time or several at once. You can also print selections of several sheets at the same time. If the data that you want to print is in an Excel table, you can print just the Excel table.

Do any of the following:

Print a partial sheet, an entire sheet, or an entire workbook

  1. Do one of the following:

    • To print a partial sheet, click the sheet, and then select the range of data that you want to print.

    • To print the entire sheet, click the sheet or the sheet tab.

    • To print a workbook, click any of its sheets.

  2. On the File menu, click Print.

  3. On the Printer pop-up menu, select the printer that you want.

  4. Next to Print What, click the option that corresponds to what you want to print (Selection, Active Sheets, or Entire Workbook) and then click Print.

Print several sheets at once

  1. Select the sheets that you want to print.

To select

Do this

Two or more adjacent sheets

Click the tab for the first sheet. Then, hold down SHIFT and click the tab for the last sheet that you want to select.

Two or more nonadjacent sheets

Click the tab for the first sheet. Then, hold down CONTROL and click the tabs of the other sheets that you want to select.

All sheets in a workbook

Hold down CONTROL and click a sheet tab, and then click Select All Sheets on the shortcut menu.

  1. Bemærk: When multiple sheets are selected, [Group] appears in the title bar at the top of the sheet. To cancel a selection of multiple sheets in a workbook, click any unselected sheet. If no unselected sheet is visible, hold down CONTROL and click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

  2. On the File menu, click Print.

  3. On the Printer pop-up menu, select the printer that you want.

  4. Next to Print What, click Active Sheets, and then click Print.

Print selections from several sheets at once

  1. On each sheet, select the range of data that you want to print.

  2. On the File menu, click Print.

  3. Next to Print What, click Selection, and then click Print.

Print several workbooks at once

Bemærk: All of the workbook files that you want to print must be in the same folder.

  1. On the File menu, click Open.

  2. Hold down CONTROL and click the name of each workbook that you want to print.

  3. On the File menu, click Print.

Print an Excel table

  1. Click a cell within the table to activate the table.

  2. On the File menu, click Print.

  3. Next to Print What, click Selection, and then click Print.

Tip: The Layout tab in the ribbon includes more options for page setup and printing, including page orientation and headers and footers.

See also

Preview pages before you print

Set page margins

Print with landscape orientation

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×