ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   making columns flow down the page (https://www.excelbanter.com/excel-discussion-misc-queries/90389-making-columns-flow-down-page.html)

andy

making columns flow down the page
 
How do you make a column of data on a spreadsheet flow across the sheet like
newspaper copy flows (down and across the page, L to R)?
TIA, Andy

Dave Peterson

making columns flow down the page
 
David McRitchie has a macro that will "snake" the columns.
http://www.mvps.org/dmcritchie/excel/snakecol.htm

Personally, I'd copy into MSWord (maybe hitting NotePad if MSWord slows down
when I paste).
Then use MSWord's Format|Column to make life easy.

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

andy wrote:

How do you make a column of data on a spreadsheet flow across the sheet like
newspaper copy flows (down and across the page, L to R)?
TIA, Andy


--

Dave Peterson


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com