#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Printing Columns

If I have data in one long column how do I wrap the column so that it will
print 2 or more columns on each page or do I have to move the data to Access?
Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,290
Default Printing Columns

There is nothing built-in that will do that.
You can paste into Word and use Format | Columns
-or -
David McRitchie has some vba code to experiment with in Excel...
http://www.mvps.org/dmcritchie/excel/snakecol.htm
-or -
Consider a commercial alternative.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"KevinP"
wrote in message
If I have data in one long column how do I wrap the column so that it will
print 2 or more columns on each page or do I have to move the data to Access?
Thanks
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Missing columns when printing backbutton Excel Discussion (Misc queries) 1 February 1st 06 03:04 AM
Printing Double Columns AjM Excel Discussion (Misc queries) 3 January 7th 06 10:34 PM
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns Sam via OfficeKB.com Excel Worksheet Functions 4 July 14th 05 09:15 PM
Hidden Columns in Shared Workbooks Rotary Excel Discussion (Misc queries) 1 July 9th 05 12:28 AM
Want labels of columns to display on each page when printing work. justinlind44 Excel Discussion (Misc queries) 4 March 28th 05 03:29 PM


All times are GMT +1. The time now is 10:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"