Excel Office 365 Print Options – [Simple & Quick Steps to Print]
Tags: excelpreface, printoptionsinexcel, exceltutorials
Published: 2020-12-04 10:34:38

---
title: Excel Office 365 Print Options – [Simple & Quick Steps to Print]
published: true
date: 2020-12-03 11:52:33 UTC
tags: ExcelPreface,PrintOptionsinExcel,ExcelTutorials
canonical_url: https://geekexcel.com/excel-office-365-print-options-simple-quick-steps-to-print/
---

In this article, you will learn the **Print Options in Excel Office 365** with clear-cut images. Let’s see the various steps to print a worksheet/file in Excel. 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)**
## Print a Worksheet:

Check this too: [Print X number of pages in Excel](https://geekexcel.com/how-to-print-x-number-of-pages-in-excel-office-365/)

If you want to [**print a worksheet**](https://geekexcel.com/how-to-print-a-worksheet-or-workbook-in-excel-office-365/) from Excel, then follow the below steps.

- First, you need to **click** the **File** Tab.

![File Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/File-Tab.png)<figcaption id="caption-attachment-18589">File Tab</figcaption>

- Then, you need to **select** the **Print** option from the menu.
- Now, **click** the **Print** button on the right pane.

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

- Finally, the current worksheet will be printed based on the default page settings.

## Steps to Print a Workbook:

To [print the entire workbook](https://geekexcel.com/how-to-print-a-worksheet-or-workbook-in-excel-office-365/) that contains two or more [sheets](https://geekexcel.com/how-to-use-excel-sheets-function-in-office-365-with-examples/), follow the below instructions.

- You need to **click** the **File Tab** in the current worksheet.

![File Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/File-Tab.png)<figcaption id="caption-attachment-18589">File Tab</figcaption>

- Then, **select** the **Print** option from the menu.
- You need to **select** the **Print Entire Workbook** option from the **Settings** section.

![Print Entire Workbook](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Print-Entire-Workbook.png)<figcaption id="caption-attachment-18591">Print Entire Workbook</figcaption>

### Note:

- Excel always prints the current worksheet by default setting “[**Print Active Sheets**](https://geekexcel.com/print-current-printed-page-of-active-cell-in-excel-office-365/)“.
- It only prints the active sheets in the workbook.

## Print a Selection Range:

You can print only the **selection**  **range** in Excel. To do this, follow the below steps.

- You need to **select the cell ranges** that you want to print in the current worksheet.

![select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/3-3.png)<figcaption id="caption-attachment-18467">select the range</figcaption>

- Then, on the **File Tab, select** the **Print** option from the menu.
- You need to **select** the **Print Selection** option from the Settings drop-down list.

![Print Selection](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-8.png)<figcaption id="caption-attachment-18592">Print Selection</figcaption>

## Collated or Uncollated Print:

To do this, follow the below steps.

- If you **choose** the **Collated** option, it will [print the first copy](https://geekexcel.com/quickly-print-first-page-of-each-worksheet-in-excel-office-365/), then print the second copy, and so on.
- If you **choose** the **Uncollated** option, it will print three copies of page 1, then three copies of page 2, and so on.
- **Click** the **File Tab** in the current workbook.

![File Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/File-Tab.png)<figcaption id="caption-attachment-18589">File Tab</figcaption>

- Then, **select** the **Print** option from the menu.
- Now, you need to **select** the **Collated** or **Uncollated** option from the **Collated setting** drop-down list.

![Print options](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/2-8.png)<figcaption id="caption-attachment-18593">Print options</figcaption>

## Print Orientation:

- There is two orientation in Excel. They are **Portrait Orientation** and **Landscape Orientation (Print Options).**
-  To do this, You need to **select** the **Print** option from the **File Tab.**
- Then, **select** the **Portrait Orientation** option.

![Portrait Orientation](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/3-7.png)<figcaption id="caption-attachment-18594">Portrait Orientation</figcaption>

## Page Margin Setting:

- Go to the print setting page, then **click** the **Margin** setting drop-down list.

![Margin options](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/4-7.png)<figcaption id="caption-attachment-18595">Margin options</figcaption>

- **Click** the **Custom Margins** option, it will **open** the **Page Setup** window.
- Then, **click** the **Margins** tab. You can set the page margin value such as **Top, Left, Bottom, Right,** etc.

![Page Setup Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Page-Setup-Dialog-Box.png)<figcaption id="caption-attachment-18596">Page Setup Dialog Box</figcaption>

### Note:

- You can also drag the margin lines to change the page margins. You need to **click** the **Show Margins** at the right bottom of the print setting window.

## Print Scaling:

If the worksheet has plenty of rows or columns and you want to print all the data on one page, then you can use the **scaling** method.

- There are totally four scaling choices in Excel.
- **Fit All Rows on One Page –** This option will shrink the printout so that it fits on one page.
- **No Scaling –** It will print sheets at their actual size.
- **Fit Sheet on One Page –** This will print all data on just one page.
- **Fit All Columns on One Page –** It will shrink the printout, so it can fit on one page.

![scaling method](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/5-6.png)<figcaption id="caption-attachment-18597">scaling method</figcaption>

## Quick Print:

- To print the active worksheet quickly, you need to **click** the **Quick Print** option.
- After clicking this option, the current worksheet will be printed instantly.

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

- You can also click the **CTRL** + **P** Keys to print the current worksheet.
- The above print options in Excel are really helpful to you.
- To [print the pages in reverse order](https://geekexcel.com/how-to-print-pages-in-reverse-order-in-excel-office-365/), kindly refer to this article.

## A Short Synopsis:

In the above article, you can quickly understand the **Print Options in Excel Office 365** with clear-cut images. Leave your **feedback** in the below comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Worksheet Area in Excel- A Detailed Guide in MS Excel 365](https://geekexcel.com/a-detailed-guide-to-know-about-worksheet-area-in-ms-excel-365/)
- [Quickly Print First Page of Each Worksheet in Excel Office 365!!](https://geekexcel.com/quickly-print-first-page-of-each-worksheet-in-excel-office-365/)