» Adding non-contiguous ranges to a single contiguous range for printing in Microsoft Excel

CATEGORY - Excel Printing VERSION - Microsoft Excel 2000 , Microsoft Excel 2002

In Excel 2000 and Excel 2002, you can join non-continuous ranges to form a single contiguous range in order to print them as a single print area.

The Paste All icon is new addition to Excel 2000 and Excel 2002.
Copy two or more separate ranges of cells separately. In Excel 2000 the Paste All icon appears on the Clipboard toolbar. In Excel 2002, press Ctrl+C+C to open the Clipboard pane, or from Edit, select Clipboard.

Select a cell and click the Paste All icon. The ranges that you copied are pasted in order. Now, define these continuous ranges as a single print area and print.

Book Store:

VIEW ALL BOOKS

Recommended Books:

Email Tip

Print Tip

Add to My Tips

Rate This Tip



1	2	3	4	5

Rating: 1.88 Views: 32536

COO

Roger Posted on: 31-12-1969

There must be a better way than this. If you follow this tip none of the formatting flows to where you've pasted the data. I just want to print collums a, c, f, and g ON THE SAME PAGE. I can get them to print on seperate pages by selecting each collum with CTRL held down but they won't print on the same page.

It worked fine for me

Judy Freed Posted on: 31-12-1969

My font formatting and bold text was copied along with the text. I control clicked the columns, then selected Copy, then Paste Special, All.

Reply: COO - Roger from Richmond, IN wrote on June 9, 2003 3:55 PM EST

Alan Posted on: 31-12-1969

Hi Roger,

Why not just hide columns B, D, and E.

If you then select all the columns from A to G inclusive, it will print the ones you want, and not the ones that are hidden.

Hope that helps,

Alan.