![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Mar 2002
Posts: 3
|
I am trying to get two really long columns to print out on less pages, and I was wondering if it is possible to get the colums to go down and across the page (that is repeat the columns more than once per page) then go on to another page. So I would end up with maybe 6 columns on a page (my 2 columns, repeated 3 times) before it placed the data on the next page. Does anyone know how this can be done? Thanks in advance
|
|
|
|
|
|
#2 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: Auckland, New Zealand
Posts: 4,209
|
Quote:
tool and take a shot of the columns that you need (2) and paste side by side @ the top of your column data start. Then just set the print area to this range. |
|
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|