E=mc2
asked on
Adding a visible notation in field in Excel
I would like to add a visible notation for a specific cell in Excel which contains a formula.
For instance if the cell is showing 3500 (as a result of a formula calculation), I would like to add a small 1, or a next to it, and then
refer to that 1 or a at the end of the spreadsheet to make a note regarding that cell.
The problem is that if I add anything in the cell, it affects the formula..
Is there a way to do this?
It must show when I print the document.
For instance if the cell is showing 3500 (as a result of a formula calculation), I would like to add a small 1, or a next to it, and then
refer to that 1 or a at the end of the spreadsheet to make a note regarding that cell.
The problem is that if I add anything in the cell, it affects the formula..
Is there a way to do this?
It must show when I print the document.
ASKER
Thank you. How can I show a comment then when printing, or even when viewing a file, without having to hover over it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks.
There is an option to have Comments printed at the end of the worksheet but not sure of the indexing (1 or a) options.