How to Print a Worksheet or Workbook in Excel Office 365?
Tags: excelpreface, printaworksheetorwor
Published: 2020-09-01 04:07:05

---
title: How to Print a Worksheet or Workbook in Excel Office 365?
published: true
date: 2020-08-31 11:23:51 UTC
tags: ExcelPreface,PrintaWorksheetorWor
canonical_url: https://geekexcel.com/how-to-print-a-worksheet-or-workbook-in-excel-office-365/
---

## Print a Worksheet or Workbook in Excel:

In this tutorial, we will guide you to learn how to **Print a Worksheet or Workbook in Excel Office 365** for both the **Windows** and **Web**. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

WindowsWeb

## Windows:

### Print One or Several Worksheets in Excel:

- You have to **select the Worksheets** that you want to print.
- Go to the **File** tab, **click** the **Print** option, or **press [CTRL + P](https://geekexcel.com/print-file-shortcut-in-microsoft-excel-365/)**.
- **Click** the **Print** button or you can modify the **settings** before click the **Print** button.

![Print Worksheet](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-101.png)<figcaption id="caption-attachment-13020">Print Worksheet</figcaption>

### Print One or Several Workbooks:

- If you want to print several workbooks at the same time, make sure that all the workbooks are in the same folder.
- Then, **click** the **File** tab, **select** the **Open** option.
- You have to hold down the **CTRL** key and **click the name of each workbook** that you want to print.

![Open Options in Excel](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-85.png)<figcaption id="caption-attachment-13021">Open Options in Excel</figcaption>

- Now, **Click** the **Print** button.
- If you want to open the print preview window using a shortcut in Excel, and then we suggest you refer the following [article](https://geekexcel.com/shortcut-to-open-print-preview-window-in-excel-365/).

### Print All or Part of a Worksheet in Excel:

- Go to the worksheet, and **select the range of data** that you need to print.
- On the **File** tab, **click** the **Print** option.
- Under the **settings** option, **click** the **dropdown arrow** next to the **Print Active Sheets**. Then, **select** the appropriate **option** from the menu.

![Settings Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-55.png)<figcaption id="caption-attachment-13022">Settings Option</figcaption>

- Now, **Click** the **Print** button.

### Print an Excel Table:

- You have to **Click any cell within the table** to enable the table.
- On the **File** tab, **click** the **Print** option.
- Under the **Settings** option,  **click** the **dropdown arrow** next to the **Print Active Sheets** and then **Select** the **Print Selected Table** option.
- **Click** the **Print** button.

![Print Selected Table](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/4-21.png)<figcaption id="caption-attachment-13023">Print Selected Table</figcaption>

### Print a Workbook to a File:

- You have to go to the **File** tab, **click** the **Print** option, or simply **Press [CTRL + P](https://geekexcel.com/print-file-shortcut-in-microsoft-excel-365/)**.
- Under the **Printer** option, **Select Print to File** option.
- Now, **click** the **Print** button.
- In the **Save Print Output As** dialog box, **enter the file name** and **click** the **OK** button.
- Now, the file will be saved in your **documents** folder.

![Print to File Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/5-16.png)<figcaption id="caption-attachment-13024">Print to File Option</figcaption>

From the above steps, you can clearly understand the ways to print a worksheet or workbooks in Excel for Windows devices.

## Web:

### Print a Worksheet:

- If you want to print a range of cells, you just select those particular cell range. To print the entire worksheet, you don’t have to select anything.
- On the **File** tab, **select** the **Print** option, then **click** the **Print**  **button**.

![Click the Print Button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/6-12.png)<figcaption id="caption-attachment-13027">Click the Print Button</figcaption>

- If you selected a range of cells, but you want to print the entire worksheet, move to the **Entire Workbook ** before you **click** the **Print** button.

### Change a Selected Print Area:

- On the Worksheet, **click** and **drag to select the cells** that you want to print.
- Go to the **File** tab, **click** the **Print** option, then **click** the **Print button**.
- To print only the selected area, **Click** the **current selection** option under the **Print** option.
- To Change the print selection, **close** the **print preview** by clicking the **x, ** then repeat the above steps.
- If you have the Excel desktop application, you can set more print options. You have to **click open in the Excel** option, then **select multiple print areas** in the worksheet.

### Print a Worksheet that has hidden rows and columns:

- If you want to print the hidden rows and columns, you need to unhide them before you print the worksheet.
- If the rows or columns are hidden, it will be shown as the below example image.

![Hidden rows](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/7-7.png)<figcaption id="caption-attachment-13028">Hidden rows</figcaption>

- You have to select the range of headers surrounding the hidden rows or columns. In the below example image, select the all row headers between the rows **6** and **9** to unhide the rows **7,**  **8.**
- You have to **right-click the selection** and **choose** the **unhide**  **rows** option.

![Unhide rows](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/8-5.png)<figcaption id="caption-attachment-13032">Unhide rows</figcaption>

- Then, **click** the **File** tab, **select** the **Print** option.
- Now, **click** the **Print**  **button** for print preview.

![Print Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/9-5.png)<figcaption id="caption-attachment-13033">Print Option</figcaption>

- In the **print options** box, you need to make sure that the **Entire Sheet** is selected and **click the Print** button.

### Print a Workbook:

- If the workbook has only one **worksheet** , you can print it easily. But if your **workbook has multiple worksheets** , you need to **select each worksheet by clicking its tab** , and then print the worksheet.

![Select Sheet tabs](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/10-3.png)<figcaption id="caption-attachment-13036">Select Sheet tabs</figcaption>

- If the workbook has any hidden worksheet, you need to verify that using the following steps.
- You have to **right-click any sheet tab** , **click** the **Unhide** option.

![Unhide Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/11-1.png)<figcaption id="caption-attachment-13037">Unhide Option</figcaption>

- Now, you can print the selected workbook.

### Print a Table:

- To select all the cells in the table, **click the first cell** in the table and **hold down the Shift key** and **click** the **last cell**.
- Go to the **File** tab, **click** the **Print** option, then **click** the **Print button**.
- To print only the selected area, **Click** the **current selection** option under the **Print** option.
- If you want to see the **print preview** , then **click Print**.

### Print Page Numbers on a Worksheet:

- To print page numbers on a worksheet, you have to **click open in the Excel button**.
- Then, **insert page numbers** on the worksheet.
- Finally, **print** the worksheet.

## Bottom-Line:

In this tutorial, you can learn many ways to **Print a Worksheet or Workbook in Excel Office 365** for both the Windows and Web. Share your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!