✦Template Printable Ideas Insights

Print Excel Table on Single Page: Tips & Tricks

By

Ever found yourself struggling to fit a table into a single page in Excel? Its default behavior of breaking tables across multiple pages can be frustrating, especially when you need a quick printout. Here's a step-by-step guide on how to print a table on one page in Excel, optimizing your printouts and saving paper in the process.

Before we dive into the steps, ensure your table fits on one page. If it's too wide, you might need to adjust column widths, remove unnecessary data, or use a smaller font. Now, let's proceed with the printing process.

landing Pages in Excel

In many cases, Excel breaks tables across pages because it thinks of each page as a separate sheet. To change this, we'll need to make Excel consider all pages as one continuous sheet.

How to Create a Table in Excel
How to Create a Table in Excel
How to Set the Print Area in Excel (with pictures)
How to Set the Print Area in Excel (with pictures)
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)

We'll use the Page Setup dialogue box for this. Here's how to access it:

Accessing the Page Setup Dialogue Box

In Excel 2016 and later versions, click on the 'Layout' or 'Page Layout' tab in the ribbon. Then, click on the small dialog box launcher at the bottom-right corner of the 'Page Setup' group. In older versions, go to 'File' > 'Print', then click on the 'Page Setup' button at the bottom of the window.

Shortcut to format a table in excel.
Shortcut to format a table in excel.
[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
Create Excel Table With Specific Style - Contextures Blog
Create Excel Table With Specific Style - Contextures Blog

Alternatively, you can use the keyboard shortcut Alt + P + U (for 'Page Setup') to directly open the dialog box.

Fitting to One Page

Once in the Page Setup dialogue box, look for the 'Scaling' section. Here, you'll see options like 'Fit to: Width', 'Fit to: Height', or 'Fit to: Pages width'. These are the culprits causing your table to break across pages.

To print your table on one page, we'll use the 'Custom' scale. Here's how:

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
Multiplication table in just a few seconds in Excel 💯
Multiplication table in just a few seconds in Excel 💯
how to print a large excel spreadsheet on one page
how to print a large excel spreadsheet on one page
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 table with text that reads,'important pdf data into an excel table '
an excel table with text that reads,'important pdf data into an excel table '
Excel tables
Excel tables
  1. Click on the 'Custom scale' option in the 'Scaling' section.
  2. Set the 'Scale to' field to 100% (if your table fits within one page without zooming in or out, you might need to adjust this percentage).
  3. In the 'Width' field, set either the 'Fit to' or 'Number of pages wide' option to 1.
  4. In the 'Height' field, set either the 'Fit to' or 'Number of pages tall' option to 1.

Setting both width and height to fit 1 page ensures your entire table fits on one sheet, regardless of its size.

Adjusting Margins for Better Fitting

Sometimes, even after setting the scale to 'Custom' and fitting the table to one page, it might still not fit perfectly. In such cases, adjusting the margins can help.

In the Page Setup dialogue box, look for the 'Margins' section. Here, you can adjust the top, bottom, left, and right margins. Reducing these margins can sometimes help your table fit on one page. Be careful not to reduce them too much, as it could lead to important content getting cut off.

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 Sheets in Excel
Print Sheets in Excel
How to Insert an Excel Table Into Microsoft Word
How to Insert an Excel Table Into Microsoft Word

chk to Print Margins

To ensure your margins are indeed reducing the size of the printout, enable the 'Printer margins' option in the 'Margins' section. This will show you a preview of the margins on the same scale as your table, helping you adjust them more precisely.

Once you've adjusted the margins, click 'OK' to apply the changes and close the Page Setup dialogue box.

Checking Your Setup Before Printing

Before actually printing, it's a good idea to preview the page to ensure your table fits as expected. You can do this by going to 'File' > 'Print', or simply pressing Ctrl + P (or Cmd + P on a Mac). In the print preview, look for the 'Print Preview' tab in the ribbon. Click on it and make sure your table fits on one page.

If everything looks good, go ahead and print your table. The secret to printing a table on one page in Excel is simple: make Excel consider all pages as one continuous sheet, and adjust margins to accommodate any remaining discrepancies.