How to Print Selected Contents in Excel? A Complete Guide!!
Tags: excelpreface, excelbasics, exceltutorials, printselectedcontent
Published: 2021-01-20 11:52:34

---
title: How to Print Selected Contents in Excel? A Complete Guide!!
published: true
date: 2021-01-20 11:47:34 UTC
tags: ExcelPreface,ExcelBasics,ExcelTutorials,printselectedcontent
canonical_url: https://geekexcel.com/how-to-print-selected-contents-excel/
---

In Excel, sometimes you really don’t need to print out the entire report which wastes paper, ink, and time. Here, we will show how to **print out only the specific areas or selected contents of the spreadsheet** that you need. Let’s get started!! 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)

## Steps to print a selected area:

When printing selected content from the worksheet, you do not need to copy to a new worksheet and print. Just use the Excel settings to directly print the selected content. Please do follow the below steps:

- First, you need to select the **“File”** option from the **“[Ribbon](https://geekexcel.com/use-and-customize-ribbon-commands-in-excel-office-365-quick-ways/)“**.

![File option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/File-option.png)<figcaption id="caption-attachment-21122">File option</figcaption>

- Here, you can see the **“Print”** option. Just click it to open the print window.

![Select Print option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Select-Preview-option.png)<figcaption id="caption-attachment-21123">Select the Print option</figcaption>

- In the print window, you can see the Print Active Sheets option under the settings.

![Print Settings](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Print-Settings-2.png)<figcaption id="caption-attachment-21273">Print Settings</figcaption>

- Just click it, and you will see the three options from the drop-down list.

![Drop-Down list](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Drop-Down-list-3.png)<figcaption id="caption-attachment-21274">Drop-Down List</figcaption>

- **Print Active Sheets** : It will only print the current worksheet.
- **Entire Workbook Print** :  It can print all worksheets in the workbook.
- **Print Selection** : Only print the section you selected.
- Now, you can select the Print Selection option, to print the selected area and click the **“Print”** button.

![Print Selected Area](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Print-Selected-Area.png)<figcaption id="caption-attachment-21276">Print Selected Area</figcaption>

## Verdict:

In this short tutorial, we have described the simple steps to **print the selected contents in Excel Office 365**. Let me know if you have any **doubts** regarding this article or any other article on this site. Click here to know more about **[Geek Excel](https://geekexcel.com/)!! **

### Read Ahead:

- [**How to Print Multiple Copies in Excel Office 365 ~ Complete Guide!!**](https://geekexcel.com/how-print-multiple-copies-in-excel/)
- **[How to Check the Print Preview in Excel Office 365?](https://geekexcel.com/check-print-preview-in-excel/)**