✦Template Printable Ideas Insights

How to Print Large Tables in Excel

By

Are you struggling to print a large table in Microsoft Excel without it getting chopped off or distorted? You're not alone. Excel has a built-in print feature that can handle most tables, but when it comes to large and complex ones, you might need to adjust some settings. Let's dive into how to print a large table in Excel seamlessly.

Before we start, ensure that your table is neatly formatted with no unnecessary columns or rows. Also, headlines should be short and clear to avoid any strain on the printout. Now, let's get started.

Adjusting Page Settings

Excel rotates your data 90 degrees to fit everything on a portrait page by default. While this is handy, it can often distort your table. Let's change this.

How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
Quick Tip: Create an InDesign Table from an Excel File | Envato Tuts+
Quick Tip: Create an InDesign Table from an Excel File | Envato Tuts+
Shortcut to format a table in excel.
Shortcut to format a table in excel.

First, select the entire table. Click anywhere inside the table and drag your cursor to select all cells. Then, go to the 'Page Layout' tab in the 'Page Setup' group and click on 'Print Area'. Select 'Set Print Area'.

switching to Landscape Orientation

The 'Page Setup' dialog box will appear. Under 'Paper Orientation', choose 'Landscape'. This will make your page wider than it is tall, giving your table more space.

How to Create a Table in Excel
How to Create a Table in Excel
an excel spreadsheet in the office window
an excel spreadsheet in the office window
How do I print out table headings at the top of every page in Excel?
How do I print out table headings at the top of every page in Excel?

Use the 'Scale to Fit' feature as well. In the 'Scaling' section, enter 100%. Then click 'OK'. This ensures your table will stay the same size on the printed page.

Managing Large Tables

If your table is still too large, you might need to separate it. Select the entire table, then go to 'Data' and click on 'Text to Columns'. Follow the prompts to turn your data into a list of values, which can be moved into a new workbook or worksheet.

Sometimes, your printer might not support the paper size you need. In such cases, consider using a continuous feed printer or sending your document to a print shop.

Printing Headers and Footers Consistently

A common issue with large tables is that the headers and footers repeat on every page. Here's how to prevent this.

Select your table, then go to 'Mailings' in the 'Header' section and click on 'Edit Header'. In the 'Header' dialog box, click on 'Options'+, go to 'Paper Tray', and choose 'No, don't print on a separate page'.

Removing Multiple Headers/Footers

For tables very large, Excel might print a header on the first page only. To fix this, in the 'Page Setup' dialog box, under 'Sheet(s)', select 'Selected sheets'. Then, click on 'Watermark'. Set 'Choose watermark' to 'None'.

By applying these methods, you should now be able to print large tables in Excel without facing any distortion or misLabelling issues. However, each system can behave differently, so be patient and don't hesitate to seek professional help if needed.

How to Create and Manage a Custom Table Style in Your Excel Worksheet
How to Create and Manage a Custom Table Style in Your Excel Worksheet
an excel spreadsheet showing the number and type of items used in each project
an excel spreadsheet showing the number and type of items used in each project
Print Excel Table Only Without Print Area - Contextures Blog
Print Excel Table Only Without Print Area - Contextures Blog
how to print a large excel spreadsheet on one page
how to print a large excel spreadsheet on one page
How to Create a Table in Excel / How to Format a Table in Excel - Tutorial
How to Create a Table in Excel / How to Format a Table in Excel - Tutorial
Create Excel Table With Specific Style - Contextures Blog
Create Excel Table With Specific Style - Contextures Blog
How to enlarge an image to print on multiple pages using Microsoft Excel Tutorial
How to enlarge an image to print on multiple pages using Microsoft Excel Tutorial
the modern table layout is shown in purple, blue and green colors with numbers on each side
the modern table layout is shown in purple, blue and green colors with numbers on each side
Curious
Curious