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.