Set Excel to print one page wide by unlimited tall
Jan 29, '09 07:30:01AM • 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.)
•
You rated: 2 / 5
(8 votes cast)
[31,098 views]