printing non-adjacent cells on one page

Posted by raj on December 17, 2001 6:08 AM

Have a worksheet cells A to M between these are the raw data used in calculation cells B, D, F etc. I just want the end result to be printed on one page. I selected these cells using the control keys and setting print page as well as using page setup. But each time I get data for a particular column printed on seperate pages..Is there a way to get around this..

Posted by Mark W. on December 17, 2001 6:23 AM

Set your Print Area to include all columns A:H and
hide the columns that you don't want to print.

Posted by raj on December 17, 2001 7:59 AM

THANKS MARK. THAT DID THE TRICK