Set Excel to print one page wide by unlimited tall
Thu, Jan 29 2009 at 7:30AM PST • Contributed by: Anonymous
Thu, Jan 29 2009 at 7:30AM PST • Contributed by: Anonymous
Here's a quick Excel printing tip. Many times, you want your worksheet to fit in one page's width, but not necessarily one page's length (as longer worksheets would be unreadable). To do this, go to File » Page Setup and in the Fit To section, enter 1 page(s) wide, and then delete the number of pages tall -- just leave it blank.
This will print your spreadsheet at whatever zoom level is necessary for it to be one page wide; it will then be as long as needed to print everything. (If you ever want to print something that's one page tall by however many pages wide, you can do the opposite, too.)
This will print your spreadsheet at whatever zoom level is necessary for it to be one page wide; it will then be as long as needed to print everything. (If you ever want to print something that's one page tall by however many pages wide, you can do the opposite, too.)
•
[6,616 views]
