This might be tough one, but I figured I'd post it... why not.
I have a long list of data (about 2000 cells - one column A1 - A2000). This data changes, and occasionally I have to print all the data on 8.5/11 paper.
Is there a quick way to format this long list such that the data arranges itself in subsequent columns until it is at the end of the printable area?
That is, if one page can fit A1 to A52 in the printable area,
and the printable area goes from columns A to I in width,
is there a quick way to organise A1 to A2000 so that A1 to A52 appears in A, A53 to A105 appears in column B and so on until it reaches column I, and then starts another print-area page?
Just checking... Thanks!
I have a long list of data (about 2000 cells - one column A1 - A2000). This data changes, and occasionally I have to print all the data on 8.5/11 paper.
Is there a quick way to format this long list such that the data arranges itself in subsequent columns until it is at the end of the printable area?
That is, if one page can fit A1 to A52 in the printable area,
and the printable area goes from columns A to I in width,
is there a quick way to organise A1 to A2000 so that A1 to A52 appears in A, A53 to A105 appears in column B and so on until it reaches column I, and then starts another print-area page?
Just checking... Thanks!