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

CPEOs provide peace of mind around payroll services

The creation of these new IRS-certified service providers for small businesses clarifies some issues around traditional professional employer organizations.

QUIZ

News quiz: Senate health care bill in the spotlight

Reports related to the Republican bill to repeal many provisions of the PPACA, other tax issues, and the giant AICPA ENGAGE Conference offered a diverse reading list for June. See how much you know about recent news with this short quiz.