Printing Question

  • Thread starter Thread starter ~ck
  • Start date Start date
C

~ck

If you have a column of values like A1:A500, is there a way that when you
print you can put 3 or 4 columns on each page? Like A1:A30, then A31:A60,
then A61:A90, then page break and do the same thing on the rest of the
pages? Seems like a feature people would use. Please point me in the right
direction if there is one. TIA.
Regards,
~ck
 
David McRitchie has macro called SnakeCols that does what you like:

http://www.mvps.org/dmcritchie/excel/snakecol.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


But if it's just a one time thing, I'd copy the range and paste into word. Then
select the data and Format|columns.

In fact, sometimes the data is a better fit in Word. Word will react nicely if
you add/delete entries. (Might be useful if the data is just plain old text.)
 
Awesome, that works great. Just what I wanted.
Dave Peterson said:
David McRitchie has macro called SnakeCols that does what you like:

http://www.mvps.org/dmcritchie/excel/snakecol.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


But if it's just a one time thing, I'd copy the range and paste into word. Then
select the data and Format|columns.

In fact, sometimes the data is a better fit in Word. Word will react nicely if
you add/delete entries. (Might be useful if the data is just plain old text.)
Click to expand...
 
Just pasting in to Word and using the columns feature, I was able to get the
desired effect. Thanks.
 
For quick and dirty stuff, that's what I use, too.

But if you have to do it lots o'times, you may want to see if you can use David
McRitchie's code.

~ck said:
Just pasting in to Word and using the columns feature, I was able to get the
desired effect. Thanks.
Click to expand...
 
Back
Top