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

Method 1 – Print Only Table from an Excel Sheet

Our sample dataset is in the B4:I79 cell range.

Dataset

The worksheet has a chart, the table, and the title of the table. We want to print only the table.

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

➤ Go to File > Print (or press CTRL + P) > Settings > Print Active Sheets and choose the Print Selected Table option from the drop-down.

You will see the following in Print Preview.

Method 2 – Tricks for Adjusting Sheet with Table to Print

Trick 1 – Apply AutoFit Row Height to Reduce the Row Height

In the sample dataset, rows 5,10, and 15 have a different height from the rest of the rows.

➤ Reduce the row height using the AutoFit Row Height option from the Format feature in the Home tab. Before using the option, select the rows that you want to autofit.

You will get the output with reduced row height.

Trick 2 – Apply AutoFit Column Width to Reduce the Column Width

If the column width is larger, you can use the AutoFit Column Width option as shown in the following image.

The output will look as follows.

Trick 3 – Adjust Page Orientation and Margins

If the number of columns is more, change the orientation of the page to Landscape for printing. If the dataset is larger, change the margins from print settings.

Trick 4 – Set Print Area

➤ Go to the Page Layout tab > Print Area > Set Print Area

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

Trick 5 – Remove Any Missing Column

You may get single or multiple missing columns in the Print Preview.

To fix the issue:

Hide rows: Hide any unnecessary rows
Adjusting scaling of the print settings: Change the scaling settings. For example, you may choose the Fit All Columns on One Page to display the all columns of the dataset.

Trick 6 – 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. This increases the number of pages. That means, you are facing two issues (missing column and increased number of pages).

To fix the two issues:

Go to the View tab > Page Break Preview option.

You’ll see the following preview.

➤ Place 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.

Go to the Print Preview. No column is missing and the number of pages is reduced.

Read More: How to Print Graph in Excel

Method 3 – Make Excel Table Readable While Printing

3.1. Increase the Row Height

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

Input the row height (e.g. 50).

You will 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.

➤ Create a list of sequential numbers for a separate column namely Sort.

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

➤ Click on the Sort option in the Data tab. A dialog box appears. Select Sort from the drop-down list of the Sort by option.

Press OK to get the following print preview.

Method 4 – Things to Add to Sheet When Print Table

4.1. Common Fields for All Pages

While viewing the Print Preview, you might see that no field name or the column heading is available except for the first page.

➤ Go to the Page Layout tab > Print Titles option. In the Rows to repeat at top option, select row 4 ($4:$4)

You’ll see the name of the fields for every page.

4.2. Common Header for All Pages

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

➤ 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.