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

Cybersecurity threats proliferating for midsize and smaller businesses

This report details how SMBs can properly protect private information from breaches, design and implement a cybersecurity policy, and create safeguards for training and education.

QUIZ

Test yourself on these often confused words

The spelling checker on your word processing program can do only so much to flag problems. Your best insurance is to learn the troublesome words that trip up writers and use them correctly by the standards of formal, written English.