Results 1 to 8 of 8
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    How to footnote a formula

    In cell C1, I have a formula "A1-B1". I would like to footnote the results of the formula with a superscript number or letter. Any ideas?Thanks in advance.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Your options are fairly limited as you cannot format only part of the result of a formula. Can you not use a cell comment?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    J.L.,

    I can think on 2 posible options.
    Option 1: Create a custom number format for each cell to be noted, rather intensive and you also need to create one for all other numbers in that column so the numbers lign up and you have to use a mono spaced font like Courier New again so things ling up.
    Excel Footnotes.PNG
    Option 2: Use a footnote column next to the numbers and just make it narrow, set the vertical alignment to TOP and use a smaller font point size. IMHO this is the way to go as it is much less labor intensive. Just make sure if you do any sorts on the number column you include the footnote column.
    Attached Files Attached Files
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,629
    Thanks
    114
    Thanked 645 Times in 589 Posts
    As in you scenario the formula in C1=A1-B1, this code will concatenate an "a" then superscript it. You will have to make adjustments if you need to refer to different cells. Could not find a way to do this in excel alone. I will test further to see if I can make this work as a user function.

    HTH,
    Maud

    Code:
    Sub Superscript()
    Range("C1").Select                       'Select Cell C1
    With ActiveCell.Characters(Start:=1, Length:=50).Font     'Reset any previous superscripting
        .Superscript = False
    End With
    Range("C1").Value = CStr(Range("A1").Value - Range("B1").Value) + "a"        'Calculate the vaue of Cell C1 and change it to text
    With ActiveCell.Characters(Start:=Len(Range("C1").Value), Length:=50).Font   'set superscript of last character
        .Superscript = True
    End With
    Range("D1").Select    'offset the activecell selection so formatting executes
    End Sub

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks to all. Maude, when I change the footnote reference from "a" to, say, "1", it results in a normal font (i. e., not a superscript). Any ideas?
    Thanks.

  6. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,629
    Thanks
    114
    Thanked 645 Times in 589 Posts
    Jlkirk,

    When you replace the "a" with a 1, place a space in front of the 1 but inside the quotes as " 1". It should work as well as using a letter.
    HTH
    Maud

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks again Maude

  8. #8
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,629
    Thanks
    114
    Thanked 645 Times in 589 Posts
    More than welcome

Posting Permissions

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