How to print Excel list in two or more columns

[motoko]

Hi,

I've been trying to work this out for an age with no success.

I have a list of data in Excel that I want to print out in columns (similar to the column function in Word).

Does anybody know how to go about this?

Regards,

Motoko

 

[RichardHumphreys]

This is not an elegant solution - I'm sure there must be a better one!

Copy your Excel data and then paste it into a Word document formatted for newspaper columns.

HTH

Richard

 

[motoko]

That's what I have been doing.

As you say, not very elegant. I was after a solution within excel if possible.

 

[Hasit]

A list of data implies data in cells A1, through Axx. Is that right??

If thats the case you have a column of data already. If not then how is your data represented?

You may also want to consider looking at Dale Watson's FAQ on printing disjointed ranges on page. It might be what you are looking for.

 

[motoko]

The data I have is a list in one column, say A1 to A900.

I've had a look at dale's FAQ but it doesn't really apply to these cirmcumstances.

What I'm trying to do is to print the data in two columns per page (as I said before, similar to the column feature in word).

I'm sure there must be a way to do it.

Motoko

 

[GlennUK]

The only way I can think of is to take a picture of rows A450:A900 with the camera tool button, and place the picture to the right of A1, so that the second half of the list is next to the first.

Glenn.

 

[TonyJollans]

Hi motoko,

Without wishing to be rude, it seems to me you have the solution already. Cutting and pasting into Word might not be a very elegant solution if you do it manually, but if automated you need never know Word was being used in the background.

I'm no expert so can't come up with good code straight away, but in pseudo-code you want to do something like the following (all within Excel VBA)

Connect to Word Application
Open a new document
Format it into columns
Select and copy the Excel column to print
Paste it into the Word doc
Do any table formatting you want to control gridlines etc.
Print the Word doc
Close the Word doc
Disconnect from the Word Application

Given time I could code it properly but I'm sure there are others out there who could do it much more quickly (and probably better).

Enjoy,
Tony