Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print multiple columns from single column data?
I am trying to print relatively narrow single columns of data... in either
Excel or Word... as multiple columns of print on a page or on multiple pages, dependent on the amount of data. I want the printout to refflect results that might have alphabetized data to show as perhaps A-G on page one, G-N on page 2 and so forth. How can I accomplsh this task. The input data will change periodically as new rows are added to the file. Thanks for your assistance. -- Bobinalong |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print multiple columns from single column data?
There is no built-in way to do that in Excel. So...
You can paste the data into Word and use Format | Columns -OR - Build your own method with VBA code... http://www.mvps.org/dmcritchie/excel....htm#snakecols -OR - Find a utility that will do it. I can send you the trial version of my Excel add-in "Special Print - Side by Side", if that option interests you. Email me and ask for it - real name and location required. Remove XXX from my email address. -- Jim Cone Portland, Oregon USA "Bobinalong" wrote in message I am trying to print relatively narrow single columns of data... in either Excel or Word... as multiple columns of print on a page or on multiple pages, dependent on the amount of data. I want the printout to refflect results that might have alphabetized data to show as perhaps A-G on page one, G-N on page 2 and so forth. How can I accomplsh this task. The input data will change periodically as new rows are added to the file. Thanks for your assistance. -- Bobinalong |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I print a single column sheet as multiple columns? | Excel Discussion (Misc queries) | |||
Single column into multiple columns | Excel Discussion (Misc queries) | |||
How do I print a single column of data in two columns on one page | Excel Discussion (Misc queries) | |||
merge data from multiple columns to single column | Excel Worksheet Functions | |||
how to convert multiple columns of data into one single column? | Excel Worksheet Functions |