MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Defining single sheet print area to have non-consecutive cells

Posted by Anita on February 04, 2002 8:49 AM

Is it possible to define a print area that will print on one page 8.5 x 11 landscape that will include only certain columns/cells and not a range of columns/cells? In other words, I would like to include in my print area:

C1 - C51
D1 - D51
E1 - E51
I1 - I51
J1 - J51
K1 - K51
L1 - L51
M1 - M51
N1 - N51
O1 - O51
Q1 - Q51
S1 - S51
T1 - T51
V1 - V51
W1 - W51
X1 - X51
Y1 - Y51
Z1 - Z51
AA1 - AA51
AB1 - AB51

I would like for all of this to print on one piece of paper.
Any assistance is greatly appreciated.


Posted by Scott on February 04, 2002 12:14 PM

Yes, you can highlight these ranges while holding down the "Ctrl" key, and then set print range and page properties as you normally would. You can also create a macro to do this if the ranges are always the same.

Posted by Anita on February 04, 2002 1:10 PM

Scott -

When I do this and then print it, I get each of my groups of ranges (i.e., C1 - E51; I1 - O51) on separate pages, I can't get them to appear all on one pages. This is probably just a little "bug" of my own somewhere.....

Any ideas?

Thanks for your help!