By scaling your worksheet because that printing, you have the right to make her data fit come one page. You deserve to shrink her Excel document to fit data on a designated variety of pages utilizing the web page Setup alternative in the Page Layout tab.

You are watching: Which feature could be used to print a very long worksheet on a single sheet of paper?

Shrink a worksheet to fit ~ above one page

Click Page Layout. Click the small Dialog crate Launcher ~ above the bottom right. This opens up up the Page Setup dialog box.


Select the Page tab in the Page Setup dialog box.


Select Fit come under Scaling.

To right your record to print on one page, choose 1 page(s) large by 1 tall in the Fit to boxes.


Note: Excel will shrink your data come fit on the variety of pages specified. You have the right to also change the Fit to number to publish to multiple pages.

Press OK in ~ the bottom that the Page Setup dialog box.

See likewise

You can likewise use page breaks to division your worksheet right into separate pages because that printing. When Excel does include page breaks immediately (indicated by a dashed line), friend can likewise insert, move, or delete page breaks in a worksheet.

If friend only should print a ar of your worksheet, girlfriend can collection or clear a print area ~ above a worksheet.

This attribute is not obtainable in Excel because that the web.

If you have actually the Excel desktop application, you can use the Open in Excel button to open the workbook and scale the worksheet to fit data top top one page.

See more: How Do You Say Please In German Translation Of “Please”, Bitte, Can I Have Some More

Need an ext help?

You can always ask an experienced in the Excel technology Community or acquire in the answers community.


Need an ext help?

Expand your skills
Explore Training
Get new features first
Join Insiders

A subscription to make the many of her time
Try one month free

Was this info helpful?

Thank you! Any much more feedback? (The much more you tell us the more we can help.)Can you help us improve? (The more you tell us the an ext we have the right to help.)
What affected your experience?
Resolved mine issue
Clear instructions
Easy to follow
No jargon
Pictures helped
Didn't complement my screen
Incorrect instructions
Too technical
Not enough information
Not sufficient pictures
Any extr feedback? (Optional)
Submit feedback

Thank friend for your feedback!

What's new Store
English (United States) © 2021