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.
Microsoft ExcelMicrosoft Office
Last Comment
E=mc2
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.