Link to home
Start Free TrialLog in
Avatar of E=mc2
E=mc2Flag for Canada

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.
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Only thing that can be added to a cell without affecting the formula/result is a comment.

There is an option to have Comments printed at the end of the worksheet but not sure of the indexing (1 or a) options.
Avatar of 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
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of E=mc2

ASKER

thanks.