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.
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.
➤ 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.
That’s a simple process! You’ll see the following in Print Preview.
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.
Shortly, you’ll get the following output with 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.
Then, the output will look as follows.
Trick-03: Adjust Page Orientation and Margins
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.
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.
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!
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).
Let’s see how can you fix the two issues using the following trick.
➤ Initially, go to the View tab > Page Break Preview option.
Then, you’ll see the following preview.
➤ 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.
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).
- Print Titles in Excel Is Disabled, How to Enable It?
- Print Multiple Excel Sheets to Single PDF File with VBA (6 Criteria)
- Excel Button to Print Specific Sheets (With Easy Steps)
- How to Print Horizontally in Excel (4 Methods)
- How to Print Gridlines with Empty Cells in Excel (2 Methods)
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).
Now, input the row height (e.g. 50).
So, you’ll get the following output.
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.
➤ Then, copy the list of numbers again (CTRL + C) and paste (CTRL + V) the below cells (e.g. I30 cell).
➤ 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.
After pressing OK and deleting the Sort column, you’ll get the following print preview. Now, this table is easily understandable.
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.
➤ 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.
Now, you’ll see the name of the fields for every page.
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.
➤ 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.
After doing that, you’ll get the following output.
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.