Vpišite se z Microsoftovim
Vpišite se ali ustvarite račun.
Pozdravljeni,
Izberite drug račun.
Imate več računov
Izberite račun, s katerim se želite vpisati.
angleščina
Ta članek žal ni na voljo v vašem jeziku.

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.

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 menu, select the printer that you want.

  4. The default is to print all active sheets. To change what is printed, select Show Details.

  5. In the Print drop-down menu, select the option that corresponds to what you want to print (Selection, Active Sheets, or Entire Workbook) and then select 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 COMMAND 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.

    Note: 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 menu, select the printer that you want.

  4. Select Show Details.

  5. In the Print drop-down menu, select Active Sheets, and then select 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. Select Show Details.

  4. In the Print drop-down menu, select Selection, and then select Print.

Print several workbooks at once

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

  1. On the File menu, click Open.

  2. For adjacent files, hold down SHIFT and select the name of each workbook that you want to print. Or, for nonadjacent files, hold down COMMAND and select 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. Select Show Details.

  4. In the Print drop-down menu, select Selection, and then select Print.

Other print options

  • Select Show Details in the Print dialog box to print to a PDF file, or to set which pages to print, paper handling options, margins, and scaling.

  • The Page Layout tab in the ribbon includes more options for page setup and printing, including page orientation, paper size and whether to print gridlines and headings.

See also

Print headings or titles on every page

Print a sheet on just one page

Scale the sheet size for printing

Ali potrebujete dodatno pomoč?

Ali želite več možnosti?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Vam je bila informacija v pomoč?

Kaj je vplivalo na vašo izkušnjo?
Če pritisnete »Pošlji«, bomo vaše povratne informacije uporabili za izboljšanje Microsoftovih izdelkov in storitev. Vaš skrbnik za IT bo lahko zbiral te podatke. Izjavi o zasebnosti.

Zahvaljujemo se vam za povratne informacije.

×