View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stephen[_2_] Stephen[_2_] is offline
external usenet poster
 
Posts: 364
Default Reformat a large column, to a grid

"Stu" wrote in message
...
Is there a simple way (i.e. without writing a macro) to take a very long
column of numbers, and arrange them as a table (or a grid) for printing?

I want to print the contents of a sheet, with one really long column of
numbers but have it appear as many columns to cut down on the massive
number
of pages it would take to print the column.



There isn't a simple way to do this.
Have a look here for a discussion and suggestions:
http://www.mvps.org/dmcritchie/excel/snakecol.htm