Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i insert references (footnotes, endnotes) in ms excel?
I'm needing to insert some references or endnotes in an excel report to
explain details of a financial statement. Is there a way to do this easily? For example, if I have 8 footnotes and realize I need to add an additional one in the beginning, is there a way that all of them will change so I don't have to change 16 things? |
#2
|
|||
|
|||
I think I would just put them on a separate worksheet.
Or do you mean you've added footnote characters to existing cells (from your previous superscript question) and you want to keep them in sync. If you do, then I think it's a manual effort. (Excel really doesn't have all the features that MSWord does.) allan wrote: I'm needing to insert some references or endnotes in an excel report to explain details of a financial statement. Is there a way to do this easily? For example, if I have 8 footnotes and realize I need to add an additional one in the beginning, is there a way that all of them will change so I don't have to change 16 things? -- Dave Peterson |
#3
|
|||
|
|||
Yes, I was hoping to add a footnote character or symbol inside and existing
cell. I still haven't been able to superscript any characters, but I think you're right about reference limitations. It will have to be a manual effort. Still, I can't seem to superscript. For instance, I've followed the instructions (format, cells, font, effects), and it will superscript in "edit" mode, but as soon as I press enter (or the green check, or tab, or select another cell...) it returns to normal. It remembers that it's supposed to be superscript because when I go into "edit" mode (double click, F2, etc.) it is in still in superscript. Do you have any suggetions??? I even downloaded an add-in, but it didn't change anything. "Dave Peterson" wrote: I think I would just put them on a separate worksheet. Or do you mean you've added footnote characters to existing cells (from your previous superscript question) and you want to keep them in sync. If you do, then I think it's a manual effort. (Excel really doesn't have all the features that MSWord does.) allan wrote: I'm needing to insert some references or endnotes in an excel report to explain details of a financial statement. Is there a way to do this easily? For example, if I have 8 footnotes and realize I need to add an additional one in the beginning, is there a way that all of them will change so I don't have to change 16 things? -- Dave Peterson |
#4
|
|||
|
|||
Allan cleared the cell and the superscripting worked fine.
allan wrote: Yes, I was hoping to add a footnote character or symbol inside and existing cell. I still haven't been able to superscript any characters, but I think you're right about reference limitations. It will have to be a manual effort. Still, I can't seem to superscript. For instance, I've followed the instructions (format, cells, font, effects), and it will superscript in "edit" mode, but as soon as I press enter (or the green check, or tab, or select another cell...) it returns to normal. It remembers that it's supposed to be superscript because when I go into "edit" mode (double click, F2, etc.) it is in still in superscript. Do you have any suggetions??? I even downloaded an add-in, but it didn't change anything. "Dave Peterson" wrote: I think I would just put them on a separate worksheet. Or do you mean you've added footnote characters to existing cells (from your previous superscript question) and you want to keep them in sync. If you do, then I think it's a manual effort. (Excel really doesn't have all the features that MSWord does.) allan wrote: I'm needing to insert some references or endnotes in an excel report to explain details of a financial statement. Is there a way to do this easily? For example, if I have 8 footnotes and realize I need to add an additional one in the beginning, is there a way that all of them will change so I don't have to change 16 things? -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i insert references (footnotes, endnotes) in ms excel?
But this really didn't answer the first question.
"how to insert references (footnotes, endnotes) in ms excel" "Dave Peterson" wrote: Allan cleared the cell and the superscripting worked fine. allan wrote: Yes, I was hoping to add a footnote character or symbol inside and existing cell. I still haven't been able to superscript any characters, but I think you're right about reference limitations. It will have to be a manual effort. Still, I can't seem to superscript. For instance, I've followed the instructions (format, cells, font, effects), and it will superscript in "edit" mode, but as soon as I press enter (or the green check, or tab, or select another cell...) it returns to normal. It remembers that it's supposed to be superscript because when I go into "edit" mode (double click, F2, etc.) it is in still in superscript. Do you have any suggetions??? I even downloaded an add-in, but it didn't change anything. "Dave Peterson" wrote: I think I would just put them on a separate worksheet. Or do you mean you've added footnote characters to existing cells (from your previous superscript question) and you want to keep them in sync. If you do, then I think it's a manual effort. (Excel really doesn't have all the features that MSWord does.) allan wrote: I'm needing to insert some references or endnotes in an excel report to explain details of a financial statement. Is there a way to do this easily? For example, if I have 8 footnotes and realize I need to add an additional one in the beginning, is there a way that all of them will change so I don't have to change 16 things? -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i insert references (footnotes, endnotes) in ms excel?
Excel doesn't really make a very good word processor. There are lots of these
kind of word processing features that aren't available in excel. I think I would just put them on a separate worksheet. John wrote: But this really didn't answer the first question. "how to insert references (footnotes, endnotes) in ms excel" "Dave Peterson" wrote: Allan cleared the cell and the superscripting worked fine. allan wrote: Yes, I was hoping to add a footnote character or symbol inside and existing cell. I still haven't been able to superscript any characters, but I think you're right about reference limitations. It will have to be a manual effort. Still, I can't seem to superscript. For instance, I've followed the instructions (format, cells, font, effects), and it will superscript in "edit" mode, but as soon as I press enter (or the green check, or tab, or select another cell...) it returns to normal. It remembers that it's supposed to be superscript because when I go into "edit" mode (double click, F2, etc.) it is in still in superscript. Do you have any suggetions??? I even downloaded an add-in, but it didn't change anything. "Dave Peterson" wrote: I think I would just put them on a separate worksheet. Or do you mean you've added footnote characters to existing cells (from your previous superscript question) and you want to keep them in sync. If you do, then I think it's a manual effort. (Excel really doesn't have all the features that MSWord does.) allan wrote: I'm needing to insert some references or endnotes in an excel report to explain details of a financial statement. Is there a way to do this easily? For example, if I have 8 footnotes and realize I need to add an additional one in the beginning, is there a way that all of them will change so I don't have to change 16 things? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i insert references (footnotes, endnotes) in ms excel?
If the number has to be in a cell that already has something in I create a
number with the text box, remove the border (format textbox, line color = no line) and place it where I want it... "Dave Peterson" wrote: Excel doesn't really make a very good word processor. There are lots of these kind of word processing features that aren't available in excel. I think I would just put them on a separate worksheet. John wrote: But this really didn't answer the first question. "how to insert references (footnotes, endnotes) in ms excel" "Dave Peterson" wrote: Allan cleared the cell and the superscripting worked fine. allan wrote: Yes, I was hoping to add a footnote character or symbol inside and existing cell. I still haven't been able to superscript any characters, but I think you're right about reference limitations. It will have to be a manual effort. Still, I can't seem to superscript. For instance, I've followed the instructions (format, cells, font, effects), and it will superscript in "edit" mode, but as soon as I press enter (or the green check, or tab, or select another cell...) it returns to normal. It remembers that it's supposed to be superscript because when I go into "edit" mode (double click, F2, etc.) it is in still in superscript. Do you have any suggetions??? I even downloaded an add-in, but it didn't change anything. "Dave Peterson" wrote: I think I would just put them on a separate worksheet. Or do you mean you've added footnote characters to existing cells (from your previous superscript question) and you want to keep them in sync. If you do, then I think it's a manual effort. (Excel really doesn't have all the features that MSWord does.) allan wrote: I'm needing to insert some references or endnotes in an excel report to explain details of a financial statement. Is there a way to do this easily? For example, if I have 8 footnotes and realize I need to add an additional one in the beginning, is there a way that all of them will change so I don't have to change 16 things? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i insert references (footnotes, endnotes) in ms excel? | Excel Discussion (Misc queries) | |||
Fixed cell references | Excel Discussion (Misc queries) | |||
insert column without changing references | Excel Worksheet Functions | |||
insert picture | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel |