![]() |
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 |
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 |
All times are GMT +1. The time now is 09:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com