Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: repeat rows at bottom of printed page

  1. #1
    Join Date
    23rd June 2011
    Posts
    3

    repeat rows at bottom of printed page

    Hi,
    I've searched but can't find a suitable answer to this situation: how do you tell excel to repeat rows at the BOTTOM of each print page?
    It's easy enough in page setup to get repeat rows at the top but I want to do exactly the same at the bottom.
    The rows I want to reappear stay exactly the same (quantity, height etc) so it doesn't have to be too fancy!
    I don't think it can be done at all in page setup - unless someone else knows something different...
    Any ideas anyone?
    Thanks in advance.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    30th May 2011
    Location
    CH
    Posts
    283

    Re: repeat rows at bottom of printed page

    You are right that it cannot be done in page setup, but it can be done using extensive coding. Can you give me a clearer idea of how a typical printed part of your sheet would look like?

    Regards

    Attila

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    23rd June 2011
    Posts
    3

    Re: repeat rows at bottom of printed page

    FOR PAYROLL USE ONLYFundFunctionObjectCost CenterProject / / / / See above Run # / Screen # / Batch # / RC# / Initials I hereby certify that this timesheet is correct and support documentation for all information is available for audit.
    SignatureDatePhone Number


    This is the footer I need on every page. I wanted to send you a pdf of how it would look like but I don't see where I can send an attachment. Thanks

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    23rd June 2011
    Posts
    3

    Re: repeat rows at bottom of printed page

    Here is attachment
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    15th March 2007
    Location
    LONDON, UK
    Posts
    1,376

    Re: repeat rows at bottom of printed page

    Can you not set a footer instead of repeating rows....? Repeating rows is practically a Header anyway...

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    4th June 2012
    Posts
    1

    Re: repeat rows at bottom of printed page

    I am trying to be able to repeat a disclaimer at the bottom of every page in a large report. The text string is too long for a footer. Does anyone have a work-around? I use Excel 2010.

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    30th May 2011
    Location
    CH
    Posts
    283

    Re: repeat rows at bottom of printed page

    Hi Barngirl

    Welcome to OzGrid!! Normally you should start a new thread for a new question such as this.
    The simplest workaround for the character limit is making your disclaimer into an image.
    This link gives you great step by step instructions on how to go about doing that:
    http://www.techrepublic.com/blog/10t...d-footers/1378

    HTH

    Attila

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Repeat Rows on a Specific page range
    By susanjasmann in forum EXCEL HELP
    Replies: 1
    Last Post: September 2nd, 2010, 20:23
  2. Xl4 Page.setup Repeat Rows At Top
    By postman2000 in forum EXCEL HELP
    Replies: 6
    Last Post: August 1st, 2007, 13:14

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
  •  
porno