ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   *or footnote cells in a table? (https://www.excelbanter.com/excel-discussion-misc-queries/185939-%2A-footnote-cells-table.html)

ctc

*or footnote cells in a table?
 
How do I visually demarcate a cell to reference a note that I might list
under the Excel table? Typically this is done with either multiple asterisks
or a number to give the reader additional information about the contents of a
cell. Since the cell contains a formula and a resulting numerical value I
haven't been able to figure out how to do this.

Peo Sjoblom

*or footnote cells in a table?
 
You can use datavalidation, then select the message tab. Now when the cell
is selected there will be a little pop up frame with your info.
You can also insert a comment and you will get
a red triangle in the top right corner of the cell, when you move the cursor
over the triangle it will
pop up


--


Regards,


Peo Sjoblom


"ctc" wrote in message
...
How do I visually demarcate a cell to reference a note that I might list
under the Excel table? Typically this is done with either multiple
asterisks
or a number to give the reader additional information about the contents
of a
cell. Since the cell contains a formula and a resulting numerical value I
haven't been able to figure out how to do this.




pdberger

*or footnote cells in a table?
 
ctc

Here's a few ideas:

1) Format the cell a color, and cell holding the corresponding note the
same color.
2) Put the asterisk in the cell next to the data.
3) If the data cell has a label next to it, add a number to the end of that
label, and format the number as superscript.

HTH

"ctc" wrote:

How do I visually demarcate a cell to reference a note that I might list
under the Excel table? Typically this is done with either multiple asterisks
or a number to give the reader additional information about the contents of a
cell. Since the cell contains a formula and a resulting numerical value I
haven't been able to figure out how to do this.



All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com