You are here LEARN EXCEL & VBA Excel Tips Excel General Printing Non-Continuous Areas

Printing Non-Continuous Areas

To set non-continuous areas and add them all to the Print area:

1. Select a range of cells.
2. Press Ctrl and select another area. Repeat this as many times as you need.
3. Click the Print Area icon (if the icon is displayed in the Standard toolbar).
From the File menu, select Print Area, and then Set Print Area.
Each area within the print area will be printed on a separate page.

To combine non-continuous ranges into a single range in Excel 2000, Excel 2002 and Excel 2003:

1. Copy each range (in Excel 2000, the Clipboard can hold up to 12 different copied areas).
2. In Excel 2000, press Ctrl+C+C to display the Clipboard; in Excel 2002 & Excel 2003, press Ctrl+C+C to open the Clipboard Task Pane.
3. Select the Paste All icon and paste all copied ranges into one single range.
Screenshot // Printing Non-Continuous Areas
Printing Non-Continuous AreasPrinting Non-Continuous AreasPrinting Non-Continuous Areas