Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Goose Creek, South Carolina, USA
    Posts
    108
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Formatting - Cell Addresses

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

    (Not just "Column and Row Headings)

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Formatting - Cell Addresses

    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

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Goose Creek, South Carolina, USA
    Posts
    108
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Formatting - Cell Addresses

    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •