Excel: Print Multiple Ranges

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: I want to print five sections of my worksheet, but the print areas are not next to each other.

Strategy: Choose the first range to print and use Page Layout, Print Area, Set Print Area.

Choose the next range to print. This time, a new menu item is available. Choose Page Layout, Print Area, Add to Print Area.

You can continue adding additional ranges to the print area.

Gotcha: Unfortunately, Excel will add a page break between each section of the print area.

  1. Add non-adjacent print ranges.