+ Reply to Thread
Results 1 to 7 of 7

unique and repeatable footer, possible?

  1. #1
    Forum Contributor
    Join Date
    11-10-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    229

    unique and repeatable footer, possible?

    Hello,

    I need to make an excel version of the .doc attached. The problem is that you cannot repeat the footer but only the header. While I would like to have both the header and the footer repeated in every page, plus when it comes to the footer you get 3 boxes while I'd just need one unique box.... is it possible to do that? Repeat the footer for multiple pages, as the header, and in one unique box?

    thanks!

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: unique and repeatable footer, possible?

    First, nothing is attached.
    Second, excel allows for headers and footers and they usually repeat.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Contributor
    Join Date
    11-10-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    229

    Re: unique and repeatable footer, possible?

    Sorry I didn't explain myself, my problem is that you can't really format the footer, like applying a symbol on the footer, I have attached the .doc file, basically I'd like to create a footer with that logo but I see that in excel i can't insert an image. OR make a formatted footer like the one that appears on the header on the attached .doc

    or is this possible?

    thanks in advance
    Alex
    Attached Files Attached Files

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: unique and repeatable footer, possible?

    Select Custom Footer, select one of the sections, then press the Insert Picture button.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Contributor Steve N.'s Avatar
    Join Date
    12-22-2011
    Location
    USA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    298

    Re: unique and repeatable footer, possible?

    You can save the logo as a picture. I recommend you resize the pic so it is about .5 inch high and will fit in the footer nicely. Once you have your logo saved as a picture and it is the correct size, you can Insert the log as a picture directly into the footer.

    From Insert tab - select Header & Footer and scroll to the footer at the bottom of page. Click into the desired footer cell; left, middle, or right and then click on the Header/Footer Design Tab and select 'Picture' from the H&F Elements group. Select the logo pic you saved from the appropriate folder and there ya go.

    If you have any problems, hit me back...
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    11-10-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    229

    Re: unique and repeatable footer, possible?

    ok thank you it worked!

  7. #7
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: unique and repeatable footer, possible?

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Duplicating Graphs for Repeatable Worksheets
    By cgermanjr in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-22-2013, 06:08 AM
  2. A formula to give most repeatable number in a row
    By LeapingLizard in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-28-2013, 01:25 PM
  3. Same ROWS Repeatable in Footer?
    By N1ckster in forum Excel General
    Replies: 0
    Last Post: 01-13-2013, 02:39 PM
  4. Inserting unique footer in Wookbook
    By WLHCOMP in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2012, 01:35 AM
  5. [SOLVED] How can i filter all repeatable 3 number combinations ?
    By Apocalypse in forum Excel General
    Replies: 9
    Last Post: 05-27-2012, 05:24 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