1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to "flow" a excel spreadsheet while printing

Discussion in 'Microsoft Office' started by dingdongdingding, Jan 19, 2010.

  1. dingdongdingding

    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.
     
  2. Abel MacAdam

    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.
    > .
    >
     
  3. dingdongdingding

    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.
    > > .
     
  4. ANONYMOUS

    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
     
  5. dingdongdingding

    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
     
  6. ANONYMOUS

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

    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
     

Share This Page