Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Footnotes (XL97 SR2)

    I have a user who has a spreadsheet that he wants to insert into a Word document. But, he wants to use footnotes for some of the cells, and he wants it to work like Word's footnote feature. I don't have a clue how he could do this. When he inserts the spreadsheet into Word, it's either an embedded Excel worksheet, which doesn't have footnotes, or it's a Word object, like a picture, and he can't insert footnote indicators in the object and have them referenced at the bottom of the document. Any ideas?

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Footnotes (XL97 SR2)

    Melanie

    If you want to do some VBA, it could be done, otherwise do it manually.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Footnotes (XL97 SR2)

    Ummm, I'm looking at Word 2K not 97 - but the idea is the same. When pasting the spreadsheet - use the Edit, Paste Special menu you'll get a number of choices. In Word 2k I choose paste in RTF format. This behaves like a word table - which can be footnoted.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Footnotes (XL97 SR2)

    Bingo! Thank you SO much! I knew there had to be a way, and that someone on this board would know what it was.

Posting Permissions

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