Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Andrew
 
Posts: n/a
Default creating pages from an alphabetical list

I have a list of 1,000 plus words, sorted alphabetically in Excel. I would
like to create three-column wide pages of these words. For example, the first
page would run with words starting with letter A and the third column may end
halfway through C lettered words, with the rest of the "Cs" started at the
top of the first column of the second page, and then on to the Ds, so on.
What is the easiest way to do this?

Thanks, Andrew
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Andrew

personally, i would copy & paste them into word (if they end up in a table,
select the table, use table / convert table to text) and then select them
again and use format / columns - choose 3 and there you have it.

You could then copy & paste them back into Excel if you really needed them
in excel.

Cheers
JulieD

"Andrew" wrote in message
...
I have a list of 1,000 plus words, sorted alphabetically in Excel. I would
like to create three-column wide pages of these words. For example, the
first
page would run with words starting with letter A and the third column may
end
halfway through C lettered words, with the rest of the "Cs" started at the
top of the first column of the second page, and then on to the Ds, so on.
What is the easiest way to do this?

Thanks, Andrew



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
Creating a dynamic list Jarrod A Excel Worksheet Functions 1 November 18th 05 11:29 PM
creating a dropdown list in excel Susan Excel Discussion (Misc queries) 2 January 14th 05 09:21 PM
Extracting Values on one list and not another B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 01:48 PM
Creating a dynamic list JarrodA Excel Worksheet Functions 3 October 30th 04 04:01 AM
Creating a list from an existing list. Jad Excel Worksheet Functions 1 October 29th 04 06:00 AM


All times are GMT +1. The time now is 10:19 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"