How to Print Selected Area in Excel (2 Examples)

Basic Approach to Print Selected Area in Excel

You will need to print Worksheets on a number of occasions. There are times, however, when publishing the entire report is unnecessary, resulting in a waste of paper and time. This tutorial will show you how to print the selected area in Excel that you need.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


2 Examples of How to Print Selected Area in Excel

We’ll show you two examples of how to print selected areas in Excel in the sections below. The first is the simplest, which uses the printing choice, while the second uses the Page Layout option. We’ll use the sample data set shown in the screenshot below.

2 Examples of How to Print Selected Area in Excel

1. Basic Approach to Print Selected Area in Excel

This is the most typical method for printing a specific area. Follow the instructions below to do so.

Step 1:

  • Select the desired cells.

Basic Approach to Print Selected Area in Excel

Step 2:

  • Click on the File.
  • Then, click on the Print.
  • Select the Print Active Sheets.

Basic Approach to Print Selected Area in Excel

Step 3:

  • Choose the Print Selection.

Basic Approach to Print Selected Area in Excel

Step 4:

  • You can see the print preview in the window.

Basic Approach to Print Selected Area in Excel

Notes. To open the printing option, you can also press Ctrl  + P 

Read More: How to Print Selected Area in Excel on One Page (3 Methods)


Similar Readings:


2. Use the Page Layout Option to Print Selected Area in Excel

In addition to the previous method, you can print the selected area with another procedure by following the steps below.

Step 1:

  • Firstly, select the area.

Use the Page Layout Option to Print Selected Area in Excel

Step 2:

  • From the tab select the Page Layout.

Use the Page Layout Option

Step 3:

  • Click on the Print Area.
  • Then, select the Set Print Area.

Use the Page Layout Option

Step 4:

  • By using Ctrl + P, you may now navigate to the printing section. You’ll see in the preview that it just shows the area you’ve chosen.

Use the Page Layout Option

Notes. Click Page Layout > Print Area > Clear Print Area to eliminate a print area.

Read More: How to Change Print Area in Excel (5 Methods)


Conclusion

To summarize, I hope this article has shown you how to print a specific area in Excel. Review the practice book and apply what you’ve learned. Because of your support, we are willing to pay for projects like this.

Please don’t hesitate to contact us if you have any questions. Please leave a comment below and tell me what you think.

Your queries will be answered as quickly as possible by experts from the Exceldemy Team.


Related Articles

Bhubon Costa

Bhubon Costa

Myself, Bhubon Costa, an engineer, is currently employed with Exceldemy as an Excel & VBA Content Developer. I appreciate solving analytical difficulties, finding practical answers, and, for the most part, I enjoy taking on new tasks. I write articles on Exceldemy about various ways to get out of Microsoft Excel's stuck conditions. My passion is to leave my mark on the world through my work and to have an impact on the community who benefit from it.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo