Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,549
Default 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
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
Can I print a single column sheet as multiple columns? ahutch21 Excel Discussion (Misc queries) 1 January 25th 07 10:32 PM
Single column into multiple columns Heidi Excel Discussion (Misc queries) 3 November 1st 06 10:27 PM
How do I print a single column of data in two columns on one page Neal Excel Discussion (Misc queries) 1 January 9th 06 12:31 AM
merge data from multiple columns to single column triggerthehorse Excel Worksheet Functions 2 January 17th 05 08:19 PM
how to convert multiple columns of data into one single column? Ah 3 Excel Worksheet Functions 1 November 12th 04 03:33 PM


All times are GMT +1. The time now is 06:53 PM.

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"