Formatting - Cell Addresses

[rarlingt]

Is there a way to show cell addresses WITHIN the cell?

(Not just "Column and Row Headings)

[Andrew Cronnolly]

It's not clear what you want. Do you want the cell to hold a value and also display it's own address ?.

If you just want to show th eaddress of a cell you can use the ADDRESS() function, to which you pass the row number and column number of the cell you the address for. e.g. the following will return the Address of A1, ADDRESS(1,1) as $A$1. You can include further parameters dependant what way you want the result displayed. See Help or the function wizard for more details.
Andrew C

[rarlingt]

Yes ... the user wants to show the address AND worksheet data in the cell, although I can't think why!

It seems to me that showing the Row/Cell headings should be sufficient.

Thanks for the answer ... we'll look into it!