Forgot to add this procdure for Printing:

Procedure 3: Microsoft Word.

Assuming that the active Word document is still open.

Do the folowing:

1. On the "File" menu, click "Print" to print the document with the list of
data in columns.

Challa Prabhu


"challa prabhu" wrote:

Hi.

Procedure 1 : Microsoft Word

Do the following:

1. Open a New Microsoft Document.
2. On the 'View" menu, point to "Toolbars" and then click Drawing. The
Drawing Toolbar displays on the Document interface.
3. Click the "Text Box" icon on the Drawing Toolbar and then draw as many
columns in the page.

Important: Insert page breaks for more pages. It will be difficult to add
pages later after you create cloumns on one page. You must press Enter for
the whole page to insert an additional page.

4. After drawing the textboxes on the page, click the first text box to
select. Right-click and select "Create Textbox link". The mouse pointer
changes its appearance and then click the other text box. This way you make a
link to the whole text boxes.

Procedure 2: Microsoft Excel

1.. Now open you Microsoft Excel Workbook and then select the Worksheet when
you want the data to be copied to Microsoft Word.

2.. Select the list and then copy it to the clipboard - On the Edit menu,
click Copy.
3.. Press Alt+TAB to select your Microsoft Word document.
4. Click inside the first Textbox to position your selection.
5. Click Paste. The list you copied from Microsoft Excel will automatically
flow across all the textboxes.

Note: Your selection of Textboxes could be in any order. The list will flow
based on criteria of your Textbox selection.

Important: For easy moving of data across these application, it is
recommended that Microsoft Word document is kept opened.


Challa Prabhu

"Nite Owl Sharon" wrote:

I have a list in alphabetical order of about 1,000 items which will continue
to update and grow.

I want to print them in columns similiar to newspaper style in MS Word
without cutting and pasting.

Can this be accomplished in Excel?
--
Nite Owl Sharon