• Welcome to Tux Reports: Where Penguins Fly. We hope you find the topics varied, interesting, and worthy of your time. Please become a member and join in the discussions.

How to "flow" a excel spreadsheet while printing

D

dingdongdingding

Flightless Bird
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.
 
A

Abel MacAdam

Flightless Bird
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" wrote:

> 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.
> .
>
 
D

dingdongdingding

Flightless Bird
I actually have 1 column, not multi columns.

What do you mean by manipulate the page breaks ?

On Jan 20, 4:40 pm, Abel MacAdam
<AbelMacA...@discussions.microsoft.com> wrote:
> 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" wrote:
> > 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.
> > .
 
A

ANONYMOUS

Flightless Bird
dingdongdingding wrote:

>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
 
D

dingdongdingding

Flightless Bird
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.

On Jan 21, 5:50 am, ANONYMOUS <ANONYM...@EXAMPLE.COM> wrote:
> dingdongdingding wrote:
> >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_Multi...>
>
> 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
 
A

ANONYMOUS

Flightless Bird
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 wrote:

> 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.
>
> On Jan 21, 5:50 am, ANONYMOUS <ANONYM...@EXAMPLE.COM> wrote:
> > dingdongdingding wrote:
> > >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_Multi...>
> >
> > 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
 
D

dingdongdingding

Flightless Bird
hth... thanks very much for your advice.

On Jan 22, 8:19 am, ANONYMOUS <ANONYM...@EXAMPLE.COM> wrote:
> 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
>
> dingdongdingding wrote:
> > 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.
>
> > On Jan 21, 5:50 am, ANONYMOUS <ANONYM...@EXAMPLE.COM> wrote:
> > > dingdongdingding wrote:
> > > >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_Multi...>
>
> > > 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
 
You must log in or register to reply here.
Top