+ Reply to Thread
Results 1 to 11 of 11

How to get columns to feed over onto next page

  1. #1
    Registered User
    Join Date
    03-08-2020
    Location
    Devon, UK
    MS-Off Ver
    14.0.7237.5000 (32 bit)
    Posts
    20

    How to get columns to feed over onto next page

    What I would like to do is have two columns of a table on one page and as I add to it for it to feed over on that page If I added to the first column) and onto a new page if required.

    I have attached an example, which at the moment prints on two sides but what I would like to have is two columns on the first page, with it feeding onto another page as I add items.

    Can I do this in Excel? Any ideas or solutions would be great!
    Attached Files Attached Files
    Last edited by Kalkul8; 01-30-2021 at 01:43 PM. Reason: Clarity

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,343

    Re: How to get columns to feed over onto next page

    ...you forgot to attach...
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    03-08-2020
    Location
    Devon, UK
    MS-Off Ver
    14.0.7237.5000 (32 bit)
    Posts
    20

    Re: How to get columns to feed over onto next page

    ....just like the last time I posted. I'll get the hang of it soon! Thanks for spotting my mistake.

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,343

    Re: How to get columns to feed over onto next page

    I'm not sure I understand the difficulty.

    Unless you've selected a particular range Excel will print on as many pages as necessary, onto a 3rd page as you add more data.

  5. #5
    Registered User
    Join Date
    03-08-2020
    Location
    Devon, UK
    MS-Off Ver
    14.0.7237.5000 (32 bit)
    Posts
    20

    Re: How to get columns to feed over onto next page

    Sorry, let me try and explain it again.

    The file that I sent shows a single column on the left-hand side. It prints as two pages as you would expect. I'd like to achieve the table being shown as two columns on the first page, with the second continuing from the first. Then as I add items I'd like it to feed over to the second side.

    I hope that this makes more sense!

  6. #6
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,343

    Re: How to get columns to feed over onto next page

    Sorry, I still don't follow.

    The sheet contains two columns on the 'left' not a single column.

    Are you saying you want just column A to print, spilling over on to two pages, and then you want column B to carry on printing on page 2 the spilling into page 3.

  7. #7
    Registered User
    Join Date
    03-08-2020
    Location
    Devon, UK
    MS-Off Ver
    14.0.7237.5000 (32 bit)
    Posts
    20

    Re: How to get columns to feed over onto next page

    Thanks for your reply, Richard. OK, let me see if I can explain.
    • The sheet that I attached has two columns on the left-hand side with the headings Food Group and Food, giving me my table.
    • I will add items as time goes on so the columns will get longer and will need to spill over. The additions could be in either column.
    • I would like to see the table (2 columns) spill over onto the right-hand side of the page first and then onto a second page when the first page is full.
    • When I print, I want to see a page with a table on the left and on the right so creating a full and balanced page with the maximum amount of information that can be accommodated on it.

    I hope that I am making sense!

  8. #8
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,343

    Re: How to get columns to feed over onto next page

    Your OP talked about Printing on a second page. Printing the two columns will automatically cause a new sheet of paper, i.e. a 2nd 'page' to be printed.

    Are you really talking about what you SEE on screen and do you have the 'Page Layout' view set rather than the 'Normal', and by 'spill over to the right hand side of the page', do you mean spill over to the right hand side of the SCREEN?

  9. #9
    Registered User
    Join Date
    03-08-2020
    Location
    Devon, UK
    MS-Off Ver
    14.0.7237.5000 (32 bit)
    Posts
    20

    Re: How to get columns to feed over onto next page

    Hello Richard,

    Thanks for your reply.

    I found this explanation so I hope that it helps to explain what I am trying to achieve.

    To clarify my problem: Currently, my pages look like that

    A B C
    A B C
    A B C
    A B C
    . . .
    But what I want is this:

    A B C A B C A B C
    A B C A B C A B C
    A B C A B C A B C



    I found this at https://superuser.com/questions/4149...-column-layout

    For your questions:
    My comments are from what I see on screen so I'd like to see the layout above and be able to print it like that.
    • I have created my table in the normal view.
    • I would like to see my two columns in my table spill over from the left-hand side of the screen to the right as the number of items increases and then to a second page as the list grows and so on.


    I hope that this helps.

  10. #10
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,343

    Re: How to get columns to feed over onto next page

    Hi,

    I'm not aware that there is any existing functionality that can achieve that directly.

    You'd need a macro to work out how many columns of the sheet to use and the number of rows per 'page'. Then the macro would need to cut blocks of data from column A & B to say C & D, then delete the rows that are empty and repeat the process for as many times as necessary

  11. #11
    Registered User
    Join Date
    03-08-2020
    Location
    Devon, UK
    MS-Off Ver
    14.0.7237.5000 (32 bit)
    Posts
    20

    Re: How to get columns to feed over onto next page

    Thanks for your message Richard and for checking this out. It looks like some work would need to go into doing as you suggest and I don't think that I have the time, unfortunately. I certainly don't have the knowledge! Thanks for your help and advice.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Feed information from multiple columns into one
    By jlara0687 in forum Excel General
    Replies: 5
    Last Post: 12-14-2018, 09:40 AM
  2. [SOLVED] Feed names from one column to other columns
    By jlara0687 in forum Excel General
    Replies: 8
    Last Post: 12-14-2018, 08:44 AM
  3. Replies: 3
    Last Post: 10-30-2017, 12:41 AM
  4. Export to PDF and have columns 1 to 15 on page 1 and 16 to 30 on page 2
    By beejay67 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2017, 12:04 PM
  5. I need one workbook page to feed selected data to others!
    By Rich19041980 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-26-2015, 09:10 AM
  6. Need Columns to Feed to Replicated Questionnares
    By ablits1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-07-2014, 11:46 AM
  7. Print a 15000 line list of 2 related columns in 4 columns per page.
    By jriver03 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-25-2012, 05:23 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1