Office challenge: What's the most efficient way to print different areas of the same Excel sheet?

In this week's challenge, test your Excel skills by showing readers how to print selected views of their data, efficiently.

One of your users prints different areas of the same sheet often, and she's tired of having to specify the areas every time she wants to print. Can you help her print more efficiently? There's more than one way to help her and as usual, I encourage efficiency, especially if your solution is one that you can teach her to implement as the workbook grows.


Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks