| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I place a footnote in an Excel cell?
I have information in several cells that need further explanation. I want to
footnote the data in these cells so that the reader of the Excel spreadsheet can be directed to the footnote at the bottom of the sheet. Please tell me how to footnote the data in the cell. Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I place a footnote in an Excel cell?
There are no footnotes for excel, you use a hyperlink to some info at the
bottom and a comment to indicate where to click that hyperlink in a cell -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "janw" wrote in message ... I have information in several cells that need further explanation. I want to footnote the data in these cells so that the reader of the Excel spreadsheet can be directed to the footnote at the bottom of the sheet. Please tell me how to footnote the data in the cell. Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I place a footnote in an Excel cell?
Excel has no footnote feature.
Cell comments are the next best thing. In the comment you could direct the reader to some manually entered notes you placed at bottom of sheet. Just as easy to enter the notes in the comment IMO. Gord Dibben MS Excel MVP On Thu, 27 Jul 2006 14:07:02 -0700, janw wrote: I have information in several cells that need further explanation. I want to footnote the data in these cells so that the reader of the Excel spreadsheet can be directed to the footnote at the bottom of the sheet. Please tell me how to footnote the data in the cell. Thank you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I place a footnote in an Excel cell?
Well, strictly speaking, I don't think they'd be called footnotes. However,
you can add comments to cells and choose how you display and/or print them. Having added a comment to a cell, hovering over it with the mouse will display it ... or you can choose in Tools | Options | View tab | Comment & indicator to show it all the time. Use Page Setup | Sheet | Comments: at end of sheet to print them at the end of the sheet, like a footnote ;-) Regards Trevor "janw" wrote in message ... I have information in several cells that need further explanation. I want to footnote the data in these cells so that the reader of the Excel spreadsheet can be directed to the footnote at the bottom of the sheet. Please tell me how to footnote the data in the cell. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding footnote to cell in Excel | Excel Discussion (Misc queries) | |||
| Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
| How do I place diagonal lines in a cell in Excel. | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Linear Mode
