Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Rearranging aTable
I created a worksheet consisting of two relatively narrow columns. But it's
about 7,000 rows deep. I'd like to rearrange it so I'd have five sets of column pairs on a single page, so I could print it using one fifth the paper. Assuming there are 40 lines per page, I'd then want page 1 to hold items 1-40 in the Columns A and B, then items 41-80 in rows C and D, etc.. Is there a simple command to do this? if not is there a simple macro? -- PT |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rearranging Data Help... | Excel Discussion (Misc queries) |