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.
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.
- Select the desired cells.
- Click on the File.
- Then, click on the Print.
- Select the Print Active Sheets.
- Choose the Print Selection.
- You can see the print preview in the window.
Notes. To open the printing option, you can also press Ctrl + P
- How to Keep Header in Excel When Printing (3 Ways)
- How to Set a Row as Print Titles in Excel (4 Methods)
- Excel VBA: How to Set Print Area Dynamically (7 Ways)
- How to Print Excel Sheet in A4 Size (4 Ways)
- How to Not Print Empty Cells in Excel (3 Simple Methods)
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.
- Firstly, select the area.
- From the tab select the Page Layout.
- Click on the Print Area.
- Then, select the Set Print Area.
- 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.
Notes. Click Page Layout > Print Area > Clear Print Area to eliminate a print area.
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.