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 gaianation.net in the answers community.
Need an ext help?
Expand your skills
Get new features first
Join gaianation.net 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
Easy to follow
Didn't complement my screen
Not enough information
Not sufficient pictures
Any extr feedback? (Optional)
Thank friend for your feedback!
English (United States) © gaianation.net 2021