+ Reply to Thread
Results 1 to 2 of 2

Footers with cell range

  1. #1
    Registered User
    Join Date
    03-16-2023
    Location
    Wirral, England
    MS-Off Ver
    365
    Posts
    2

    Footers with cell range

    similar to how rows can be repeated at the top of a page how can i do the same at the bottom of a page as a footer?

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,911

    Re: Footers with cell range

    Hi, as far as I know there's no option for that, you'll have to write a macro to do that.
    I would suggest a macro that selects the same range you normally set for the top rows and place is as left footer when printing
    It should be triggered with a beforePrint Event
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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. Macro to modify chart sheets (resize, add headers/footers, change date range)
    By seattletimebandit in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-02-2013, 08:31 PM
  2. Replies: 1
    Last Post: 01-10-2013, 04:27 AM
  3. Footers
    By vandest1 in forum Excel General
    Replies: 4
    Last Post: 04-30-2009, 11:47 AM
  4. [SOLVED] Can I use cell contents to update footers in excel?
    By GregW in forum Excel General
    Replies: 2
    Last Post: 08-15-2005, 02:05 PM
  5. [SOLVED] Footers in Excel
    By Hans in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-19-2005, 11:06 AM
  6. FOOTERS
    By rachel@cpa in forum Excel General
    Replies: 2
    Last Post: 03-02-2005, 02:06 PM
  7. [SOLVED] Footers
    By rachel@cpa in forum Excel General
    Replies: 2
    Last Post: 02-24-2005, 03:06 PM
  8. Footers
    By Aurora in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-11-2005, 12:06 PM

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