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

BY STANLEY ZAROWIN

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.

SPONSORED REPORT

A new line of business to consider

Technology assessments may open the door to new engagement opportunities for your firm. What is a technology assessment? How do you perform one? JofA Tech Q&A author J. Carlton Collins shows you in a detailed explanation.

FEATURE

Maximizing the higher education tax credits

A counterintuitive strategy can save taxes by including otherwise excludable scholarships in gross income.