How to Print Excel Sheet with Table (4 Methods + Tricks)

Most likely you know about the process of printing an Excel sheet. What if you want to print the sheet with a table? In this article, I’ll show 4 methods as well as special tricks on how to print an Excel sheet with a table.


Download Practice Workbook


1. Print Only Table from an Excel Sheet

Let’s introduce today’s dataset as shown in the following screenshot. Here, the Sales Report is given along with the necessary information e.g. Sales Rep, Product ID and Category, States, Price, Quantity, Sales, and lastly Discount. More importantly, the dataset belongs to the B4:I79 cell range.

Dataset

Now, I’ll show how to print this type of working sheet including the table.

In the first method, you’ll see a simple method i.e. print only a table from a sheet. Let’s say, a chart, the title of the table, and the table itself are available in your dataset. And you need to print only the table except for the other things. In such a situation, this method will be handy for you.

How to Print Excel Sheet with Table Print Only Table in Excel Sheet

Just go to File > Print (or press CTRL + P) and choose the Print Selected Table option from the drop-down list of the Print Active Sheets under Settings.

How to Print Excel Sheet with Table Print Only Table in Excel Sheet

That’s a simple process! You’ll see the following in Print Preview.

How to Print Excel Sheet with Table Print Only Table in Excel Sheet

Read More: How to Print Excel Sheet with Header on Every Page in Excel (3 Methods)


2. Tricks for Adjusting Sheet with Table to Print

In this method, I am sharing 6 special tricks that will fascinate you to adjust or fit a table for printing.

Trick-01: Apply AutoFit Row Height to Reduce the Row Height

If you look closely at the dataset, you’ll find that there are irrelevant gap in the rows (e.g. row 5,10, and 15).

➤ Luckily, you can easily reduce the row height using the AutoFit Row Height option from the Format feature in the Home tab. Before using the option, make sure that you have selected the rows that you want to autofit.

How to Print Excel Sheet with Table Tricks for Adjusting Table to Print

Shortly, you’ll get the following output with reduced row height.

Reduced Row Height

Trick-02: Apply AutoFit Column Width to Reduce the Column Width

Likewise, if the column width is larger, you may utilize the AutoFit Column Width option as shown in the following image.

How to Print Excel Sheet with Table Tricks for Adjusting Table to Print

Then, the output will look as follows.

Reduced Column Width

Trick-03: Adjust Page Orientation and Margins

Moreover, if the number of columns is not fewer, you change the orientation of the page to Landscape. Besides, if the dataset is larger, you may change the margins.

How to Print Excel Sheet with Table Tricks for Adjusting Table to Print

Trick-04: Set Print Area

Sometimes, you may see only 1 page in the Print Preview section. So, you need to set the print area in such a situation.

➤ Just go to the Page Layout tab > choose the Set Print Area option from the drop-down list of the Print Area option.

Set Print Area

Thus, you’ll all pages in the Print Preview section.

Trick-05: Remove Any Missing Column

Often, you may get single or multiple missing columns in the Print Preview. Therefore, you need to fix the issue.

Remove Missing Column in Excel Table before Print

Fortunately, there are some popular methods to fix it.

  • Hide rows: You may hide any unnecessary rows if you think. Thus, you can easily fix the problem as shown in the below image.
  • Adjusting scaling of the print settings: Furthermore, you may change the scaling settings. For example, you may choose the Fit All Columns on One Page to display the all columns of the dataset.
  • Another outstanding way to fix the issue. See the next trick!

Hide Rows

Trick-06: Reduce the Number of Unnecessary Pages

If you go to the Print Preview, you’ll find a missing column namely “Discount” that creates an unnecessary page. Therefore, the whole number of pages is increased. That means, here you are facing two issues (missing column and increased number of pages).

Remove Missing Column in Excel Table before Print

Let’s see how can you fix the two issues using the following trick.

➤ Initially, go to the View tab > Page Break Preview option.

Page Break Preview

Then, you’ll see the following preview.

Reduce the Number of Pages in Excel Table before Print

➤ Now, move the cursor between the Sales and Discount columns(columns H and I). And, drag the cursor to the right till the end of column I.

Reduce the Number of Pages

Finally, if you go to the Print Preview, you’ll find no column is missing and the number of pages is reduced (see the lower-left part of the image).

Reduce the Number of Pages in Excel Table before Print

Read More: How to Adjust Print Settings in Excel (8 Suitable Tricks)


Similar Readings:


3. Make Excel Table Readable While Printing

To make the table more visually understandable, you may follow the two methods.


3.1. Increase the Row Height

If the row height is smaller, it may reduce the readability. So, increase the row height (go to the Row Height option from the Format feature in the Home tab).

Make Excel Table Readable

Now, input the row height (e.g. 50).

Make Excel Table Readable

So, you’ll get the following output.

Make Excel Table Readable


3.2. Insert Blank Rows 

If your dataset is congested, you may insert an additional blank row between the existing two rows. Please follow the below steps.

➤ Firstly, create a list of sequential numbers for a separate column namely Sort.

Inset Blank Rows for Making Excel Table Readable

➤ Then, copy the list of numbers again (CTRL + C) and paste (CTRL + V) the below cells (e.g. I30 cell).

Inset Blank Rows for Making Excel Table Readable

➤ Next, click on the Sort option in the Data tab. Immediately, you’ll get a dialog box. Pick the Sort option from the drop-down list of the Sort by option.

Inset Blank Rows for Making Excel Table Readable

After pressing OK and deleting the Sort column, you’ll get the following print preview. Now, this table is easily understandable.

Inset Blank Rows for Making Excel Table Readable

Related Content: How to Print Excel Sheet in Full Page (7 Ways)


4. Things to Add to Sheet When Print Table

If your table covers multiple pages, you may add some things for a better presentation of the table.


4.1. Common Fields for All Pages

While watching the Print Preview, you might see that no field name or the column heading is available on the rest pages except for the first page. That’s not the standard format. You should mention the name of the fields for all pages.

How to Print Field Name is Missing in Excel Table

➤ To do that, go to the Page Layout tab > Print Titles option. Then, select row 4 ($4:$4) in the space after the Rows to repeat at top option.

Essential Things for A Larger Table

Now, you’ll see the name of the fields for every page.

Essential Things for A Larger Table


4.2. Common Header for All Pages

Furthermore, you may show the common header for all pages (e.g. the table creation date-time, page number, and the title of the table).

➤ To add such types of headers, turn on the Page Layout view from the View tab and click on the Add Header.

Essential Things for A Larger Table

➤ Next, go to the Header & Footer tab and insert Current Date, Current Time, and Page Number in the Header section from the Header & Footer Elements ribbon.

How to Print Excel Sheet with Table Essential Things for A Larger Table

After doing that, you’ll get the following output.

How to Print Excel Sheet with Table Essential Things for A Larger Table

Read More: How to Keep Header in Excel When Printing (3 Ways)


Conclusion

That’s the end of today’s session. Truthfully, I aggregated all the things that you might need while doing a print Excel sheet with a table. If you find this article useful, leave your thoughts and share the article with your community.


Related Articles

Md. Abdul Kader

Md. Abdul Kader

Hi! I am Abdul Kader and presently working as ‘Excel & VBA Content Developer’ at Exceldemy. I publish my articles related to Microsoft Excel here. In 2019, I completed my graduation in Urban and Regional Planning from Chittagong University of Engineering and Technology. Having extreme eagerness to learn, I want to develop my skills and capabilities higher.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo