MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Printing Multiple Selections

Posted by Brett on June 11, 2001 9:20 AM

I have a spreadsheet with columns A-K. I would like to be able to only print out certain columns like, A, C, E, etc. When I select the columns and set the print area it puts a page break after each column. Is there any way I can do this without having to hide/unhide columns whenever I have to print? Thanks for any help you can give me.

Posted by Brett on June 11, 2001 9:39 AM

Ok, I found one solution that will work. I made a macro that hides the appropriate columns, prints the report, and then unhides the columns. Is this the best way to do this or is there something better? Thanks again.

Posted by Ben O. on June 11, 2001 10:42 AM

That is the only method as far as I can tell. Excel simply does not print non-adjacent print areas on the same page.

-Ben O.

Posted by AB on June 11, 2001 10:53 AM

Keep in mind, it is possible to paste multiple picture links (of non-adjacent ranges) to a seperate sheet and then simply print that sheet.

AaronThe Excel Logic Page

Posted by Joe Was on June 11, 2001 11:35 AM

Copy your columns to a blank sheet, in any order you want. Then select the columns on that sheet and print. Then delete the columns and return to your main sheet. All in one macro or as a series of mouse functions. JSW

Posted by IML on June 11, 2001 12:06 PM

Another option would be to use the group function under data - group and outline -group.
You could hide all the columns by clicking on the number 1. Of course, there is nothing wrong with the macro route..
good luck.