Printing different views in Excel
Custom Views in Excel is the easiest and best way to view or print the same worksheet in different ways because you can apply sort and filter, have different headers and footers, different page orientation and hide columns and rows as part of a view. You can then switch easily from one view to another without having to do anything further or learn any shortcuts. I love using Custom Views because of its simplicity alone.
Keep Up with TechRepublic