1. column
  2. TECHNOLOGY Q&A

Excel Can Print an Entire File Even With a Mix of Worksheet Orientations

BY STANLEY ZAROWIN

Please note: This item is from our archives and was published in 2009. It is provided for historical reference. The content may be out of date and links may no longer function.

Related

TOPICS

Some of the worksheets in my Excel files are in landscape orientation and some are portrait. To maintain the orientations when I print the entire file, I print each worksheet separately, which is time-consuming. Is there some way to do the task in one print order?

Obviously you never tried to print the mixed-oriented file in one shot. If you had, you would have discovered that Excel anticipated your problem: It keeps track of the orientation and prints each worksheet correctly. This works in both Excel 2003 and 2007.

Don’t feel bad about the oversight: Consider the experience a gentle nudge to encourage you to further explore the abilities of your software. You may waste a few sheets of paper now and then, but it’s a small investment for what you may learn.