How to "flow" a excel spreadsheet while printing

[dingdongdingding]

I have a long vertical excel spreadsheet. When I print it, it
occupies the left portion of the paper. I manipulate the printer
settings so that it occupies 2 columns. However, I'm not able to port
the settings across printers and I have to set it again when I
distribute the spreadsheet.

Is there a setting in Excel which allows me to flow the vertical
columns into multiple columns ? eg left, centre, right on 1 page ?

Thanks very much in advance for your advice.

 

[Abel MacAdam]

As far as I know you need to split up the multi column work sheet over
several worksheets. Start by selecting the print area on each work sheet.
When you want to print, select all work sheets. Next press print.

Alternative, create a print area, and manipulate the page breaks.

 

[dingdongdingding]

I actually have 1 column, not multi columns.

What do you mean by manipulate the page breaks ?

 

[ANONYMOUS]

I have a long vertical excel spreadsheet. When I print it, it
occupies the left portion of the paper. I manipulate the printer
settings so that it occupies 2 columns. However, I'm not able to port
the settings across printers and I have to set it again when I
distribute the spreadsheet.

Is there a setting in Excel which allows me to flow the vertical
columns into multiple columns ? eg left, centre, right on 1 page ?

Thanks very much in advance for your advice.

You need a macro for this and so read this article:

<http://excel.tips.net/Pages/T002219_Printing_a_Single_Column_in_Multiple_Columns.html>

In future, please post excel queries in Excel newsgroups because Tom
Willet with his small manhood (& Milly whatever - a madame for Peter
Foldes' escort agency) doesn't like excel questions here!.

hth

 

[dingdongdingding]

Thanks... it helps. But I now understand my problem better. Actually,
I have 2 columns instead of 1. It's like a name value pair. The
Macro only recognise 1 column. What I'm doing now is to run the macro
2 times on each column, then cut and paste the columns from the
different speadsheet. I wonder if there is anyway to alter this macro
easily to cater for multi columns. I ask cause I don't know how to
write the Macro. Thanks again very much for your help.

 

[ANONYMOUS]

You can get help in modifying the macro here:

http://peach.ease.lsoft.com/archives/excel-l.html
http://peach.ease.lsoft.com/archives/excel-g.html

I suggest post your query again on those newsgroups but include the link I
provided so that they can understand the problem. They are experts and so they
might have ready made solution in their repository. This type of problem is
quite common and solutions have already been found.

You need to create an account on that forum/newsgroup so please use your yahoo
email so that it can be verified before a solution can be given. The solution
will arrive in your mail box.

hth

 

[dingdongdingding]

hth... thanks very much for your advice.

You can get help in modifying the macro here:

http://peach.ease.lsoft.com/archives/excel-l.htmlhttp://peach.ease.lsoft.com/archives/excel-g.html

I suggest post your query again on those newsgroups but include the link I
provided so that they can understand the problem.  They are experts andso they
might have ready made solution in their repository.  This type of problem is
quite common and solutions have already been found.

You need to create an account on that forum/newsgroup so please use your yahoo
email so that it can be verified before a solution can be given.  The solution
will arrive in your mail box.

hth