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.