Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Distribute two columns evenly over several columns
I have two columns that are related, name and score, that run from A2:B335.
I would like to keep these columns together and have them distributed evenly over multiple columns. For example to have these two columns distributed across 10 columns for 67 rows. This is primarily for formatting and printing reasons. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Distribute two columns evenly over several columns
I like to copy the data into MSWord and use MSWord's builtin ability to do
column layout. If that doesn't work for you, David McRitchie has a macro that will "snake" the columns. 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 Carl W. wrote: I have two columns that are related, name and score, that run from A2:B335. I would like to keep these columns together and have them distributed evenly over multiple columns. For example to have these two columns distributed across 10 columns for 67 rows. This is primarily for formatting and printing reasons. Thank you. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Distribute two columns evenly over several columns
The suggested MSWord column formatting worked great.
Thank you. "Dave Peterson" wrote: I like to copy the data into MSWord and use MSWord's builtin ability to do column layout. If that doesn't work for you, David McRitchie has a macro that will "snake" the columns. 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 Carl W. wrote: I have two columns that are related, name and score, that run from A2:B335. I would like to keep these columns together and have them distributed evenly over multiple columns. For example to have these two columns distributed across 10 columns for 67 rows. This is primarily for formatting and printing reasons. Thank you. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
evenly distribute numbers across a range | Excel Worksheet Functions | |||
Columns distributed evenly in worksheet | Excel Discussion (Misc queries) | |||
Divide numbers and distribute evenly. | Excel Worksheet Functions | |||
Distribute values evenly in two columns | Excel Discussion (Misc queries) | |||
How do you distrubute columns evenly in Excel 2000? | Excel Discussion (Misc queries) |