How to print only specific parts of an Excel document

In many cases, you may have a huge Excel file, but a specific part of that Excel file may be important to you. In this case, printing the entire Excel document is a waste of time, resources, and effort. Additionally, if you print all the data, the recipient may be confused about the actual data to focus on. Obviously, if you had some way to print only a specific part of an Excel document on a single page, that would simplify your life to a great extent. Also, if you had the option to print multiple sections of Excel on multiple pages, I'm sure that would be an idea that would be warmly welcomed as well.

In this article, we will explain how to easily print one or more parts of Excel in single or multiple pages according to your requirements, but obviously not the entire document. So let’s dive into this article, shall we?

Example Scenario

We have an Excel document with data that spans more than one page.

Now, if you press the CTRL P keys simultaneously, the Print settings page will open and it will offer you to print Preview informs you that all 7 pages of the document will be printed, and you only need a portion of the data to print. Let’s see how we can easily solve this problem.

Part 1: How to Set the Print Area and Print Only Specific Parts of the Document

Step 1: FirstSelect The data part to be printed.

After selecting the data, click the PAGE LAYOUT tab at the top.

Now, click on the drop-down menu named Print Area. From the available options, click the option that says Set the print area.

Step 2: If you look at Excel, you can see that the data you selected is now contained within a small box. This is the print area.

Step 3: Now, if you press the CTRL P keys simultaneously, in the print preview, you can see Only the data within the preset printing area will be printed. That’s all.

Section 2: How to extend the print area and print on the same page

Assuming you set the print area and everything is perfect. Suddenly you realize you have to add more data. The best part is that the new data is next to the original data. So you want the new data to be printed on the same page as the old data. We can accomplish this with 2 different solutions.

2.1: Expand the print area using Name Manager

Step 1: Click the Formulas tab in the tab ribbon. Now click on the Name Manager button in the section named Function Library.

Step 2: In the Name Manager window you will be able to view the print area created in Section 1. Click Print_Area and then click the Edit button at the top.

Step 3: Now click on CellCellSelect on the Reference field " icon.

Step 4: You will be able to view the original print area in this step. This is the print area you want to extend.

Step 5: You can drag and select the new area you want to merge with the old print area. But remember to keep the old print area within the selected line range as well.

After adding the new print area to the original print area, click the cell selection icon again.

Step 6: You will now be returned to the "Edit Name" window. Click the OK button to continue.

Step 7: Now, if you press the CTRL P keys simultaneously to open the print settings page, you will be able to see your print The range has been modified and the new line range has been successfully added to your print preview and is ready to print.

2.2: Extend the print area using page layout settings

Simply select the new area to be added to the original print area. After selecting the new area, click the Page Layout tab in the top ribbon. Now click on the Print Area drop-down menu and click on the Add to Print Area option.

That’s all. You can now view a print preview by pressing the

CTRL P keys simultaneously. The new area will be successfully added to the print preview.

Note: Please make sure that the new printing area is adjacent to the original printing area. Also, make sure the data has the same dimensions as the original print area. That is, for example, the number of columns in both print areas should be the same. If these conditions are not met, the new print area will not be considered an extension of the old print area, and the 2 print areas will be printed on 2 different pages.

Section 3: How to add a new print area and print on different pages

As mentioned in the previous section, you can set the print area, you can Expand them and print them. But the above section focuses on printing continuous data. What if you have to print data that are not adjacent and have different dimensions? Is it possible to print 2 different print areas? Well, quite possibly. But keep in mind that if the data are not adjacent, then if you try to print them, they will print on different pages rather than on the same page.

Step 1: First, select your new data set. This data can be located anywhere in the document, with any number of columns.

After selecting the data, click the

PAGE LAYOUT tab at the top.

Click the drop-down menu named "Print Area" and then click the "Add to Print Area" option.

Step 2: That’s it. If you press the CTRL P keys simultaneously, you can see that the 2 print areas are now on 2 different pages and they are ready to print.

Section 4: How to clear all print areas

Now let’s say you want to get rid of all the print areas you set and want to print the entire document. In this case, you need to clear any print areas you created. To do this, just click on the

PAGE LAYOUT tab at the top as usual. Click the Print Area drop-down menu and click the Clear Print Area option.

That’s all. All your print areas are now cleared and you are now free to print the entire document without the print area causing any trouble. enjoy!

The above is the detailed content of How to print only specific parts of an Excel document. For more information, please follow other related articles on the PHP Chinese website!