Results 1 to 3 of 3

Thread: Fixed or Absolute Cell

  1. #1

    Fixed or Absolute Cell

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have Cell C3 for example, linked to another worksheet. I want to be able to copy the row below (row 4) and insert it above row 3 but the link on the other worksheet must still show the original link i.e.C3. How can I fix that link.

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Victoria, Canada
    Excel Version
    Microsoft Excel 2013
    How about:


  3. #3
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Oregon, United States
    Excel Version
    365, Online, iOS, iOS for iPad
    Hi there, welcome to the board!

    As CheshireCat posted, you can use the INDIRECT() function. I personally don't like using this as it can be expensive in recalc. There are a lot of ways you can do this. Probably the least expensive would be INDEX(Sheet2!$C:$C,3,1), since the rows will move around. While I don't know what this application is for (which always gives us a better idea of what solutions would be best suited for your needs), I will tell you that a spreadsheet model where you don't need to insert/delete/cut anything is almost always better off. That being said I have no idea what you're doing orif this is applicable.
    Zack Barresse

Posting Permissions

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