To print Excel tables on a page, first adjust the page layout settings, including switching to landscape, setting narrow margins, confirming the paper size, and defining the printing area; secondly, use the "Scale to fit" function to set both width and height to 1 page; if necessary, you can set the print title to repeat rows or columns; finally fine-tune through the print preview, such as adjusting the row and column width, font size, etc. to ensure that the content is complete and readable.

Printing an Excel sheet on a single page can be tricky, especially if your data is spread out or include a lot of columns and rows. But with a few adjustments, you can usually fit everything neighborly on one page without losing readability.

Adjust the Page Layout Settings

Excel doesn't automatically shrink your sheet to one page — you need to tweak the layout settings manually. Go to the Page Layout tab, and look at the following options:

• Orientation : Switch to landscape mode if your sheet is wide. It gives you more horizontal space.
• Margins : Reduce the margins to "Narrow" unless you need wide margins for printing.
• Paper Size : Make sure the paper size matches what you'll be printing on (usually Letter or A4).
• Print Area : If only part of the sheet needs printing, define a print area under the Page Layout tab.

These settings alone can often help you squeeze more content onto a single page.

Scale the Worksheet to Fit One Page

One of the most effective ways to print an Excel sheet on one page is to use the Scale to Fit feature.

1. Go to Page Layout > Scale to Fit .
2. Set both Width and Height to 1 page .

This tells Excel to shrink the entire sheet so it fits within one printed page. Keep in mind that scaling too much can make text and numbers hard to read, so preview it first using File > Print > Print Preview .

Use Print Titles and Repeat Rows/Columns (If Needed)

If your sheet is large and you're trying to condense it, headers might get cut off. To make sure the top row (like column headers) appears on every printed page (even if you end up with more than one page for now), use the Print Titles feature:

• Go to Page Layout > Print Titles
• Under the Sheet tab, set Rows to repeat at top (eg, $1:$1 for the first row)

This is especially helpful if you're printing a multi-page sheet but want to keep it readable when printed on one page later.

Preview and Tweak Before Printing

Before hitting print, always use the Print Preview option. This shows exactly how your sheet will look on paper. From here, you can:

• Drag the column widths or row heights slightly smaller
• Shrink font size just a bit if needed (but not too small)
• Check if any columns or rows are getting cut off

If you see content spinning onto a second page, go back to Scale to Fit or adjust margins again.

Basically, it comes down to a mix of layout settings, scaling, and previewing. It's not complicated, but it does take a couple of small adjustments to get it right.

The above is the detailed content of How to print an Excel sheet on one page. For more information, please follow other related articles on the PHP Chinese website!