Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    174
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Absolute Absolute Cell Reference (Excel 2000)

    Is there a way to have real absolute cell reference ? For example, I like to have B2 = A1, even after I dragged the content of A1 to A2. Normally, after dragging, B2 would be euqal to A2 instead of A1.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Absolute Absolute Cell Reference (Excel 2000)

    You can use the formula =INDIRECT("A1"), but if A1 is empty, this will return 0. To get around this, you could use the slightly more complicated formula<pre>=IF(ISBLANK(INDIRECT("A1")),"",INDIREC T("A1"))</pre>


  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts

    Re: Absolute Absolute Cell Reference (Excel 2000)

    Hans
    What I love about the INDIRECT function is you can use it to refer to cells on other sheets, delete the sheets, copy new sheets and rename them back again and the formulas don't get unhappy!

    zeddy

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Absolute Absolute Cell Reference (Excel 2000)

    The one thing that IS ANNOYING with it is that it will NOT take external workbook references unless the workbook is open. You can only do this with a DIRECT reference (typing in the name/path etc)

    Steve

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Absolute Absolute Cell Reference (Excel 2000)

    Zeddy,

    That is a nice feature, but of course, you pay a price for it in performance. You won't notice it in small workbooks, but it can make a big difference in large workbooks with lots of formulas.

Posting Permissions

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