ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Print multiple columns from single column data? (https://www.excelbanter.com/excel-discussion-misc-queries/200110-print-multiple-columns-single-column-data.html)

Bobinalong

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

Jim Cone[_2_]

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