+ Reply to Thread
Results 1 to 12 of 12

Excel print rows at bottom

  1. #1
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Excel print rows at bottom

    Is there a way to print rows at bottom for every page in Excel, and at the same time have this dictate where the page breaks show up.

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: Excel print rows at bottom

    A little shy on information that is.

  3. #3
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Re: Excel print rows at bottom

    Hi. There is not more information I can give. With Excel there is the option to select which rows are printed on every page (Page Layout, Page Setup, under Sheet tab, Rows to repeat at top). But there is no option for rows at bottom. I would say it may be possible to do this using VBA. But there is the added complexity that page breaks (blue dashed lines) should take this into account so that you know where one pages finishes and the next starts. Repeat: so that you know where one page finishes and the next one starts, this is the difficult bit I think.

    Attachment 625875

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: Excel print rows at bottom

    Can't open your attachment. Use the "Go Advanced" button, select "Manage Attachments", "Choose File" and click on "Upload". Close that Window.

  5. #5
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: Excel print rows at bottom

    Please Login or Register  to view this content.
    Maximum amount of Characters for all three Footers (Left, Center and Right) combined is 255.
    One other way is to insert the needed Rows every n Rows and set the Pagebreak below the inserted Rows.

  6. #6
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Re: Excel print rows at bottom

    Hi. Thanks for responding, I'll give the latter a try.

  7. #7
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: Excel print rows at bottom

    I have not tried that but if you do find a solution, would you be so kind and post it here please.
    If I have some time, I'll see if I can get something workable going.

  8. #8
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Re: Excel print rows at bottom

    Hi. I think it will be very difficult to achieve to be honest. I have pretty much given up on this one.

  9. #9
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: Excel print rows at bottom

    I have been playing with it a little.
    Attached is the raw, very raw, workbook so far.
    Maybe it is a start for you.
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Re: Excel print rows at bottom

    @jolivanes. Thanks for the workbook.

  11. #11
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: Excel print rows at bottom

    This might be more like it. That is if you're still looking at data from a different sheet as footer data.
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Re: Excel print rows at bottom

    @jolivanes. Thanks for spending time on this again.
    Don't want to be rude but what I'm trying to achieve looks to be too difficult, which is to have the page breaks automatically show as you are working. Then you know where each page starts. I think I tried to convey this in post #1 and #3.
    I think others will find your work useful though.

+ 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. [SOLVED] Return Row no. for Lookup from bottom of range, ignoring bottom n no. of rows
    By naira in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 12-27-2018, 12:07 AM
  2. Rows on the bottom of a page do not show on print outs
    By KasiaVT1 in forum Excel General
    Replies: 4
    Last Post: 03-09-2015, 12:27 PM
  3. How to force excel to print at the very bottom of the page
    By Curious Dude in forum Excel General
    Replies: 2
    Last Post: 02-25-2015, 01:56 PM
  4. Replies: 9
    Last Post: 04-17-2014, 11:55 AM
  5. Replies: 0
    Last Post: 01-22-2014, 06:42 PM
  6. Print rows at bottom of each page
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-30-2011, 04:39 PM
  7. Print Rows to repeat at the bottom
    By RAJEEV CHADHA in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-22-2005, 10:06 AM

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