+ Reply to Thread
Results 1 to 3 of 3

stopping updating cells reference in excel formulas when I insert a row

Hybrid View

  1. #1
    Registered User
    Join Date
    05-20-2008
    Posts
    1

    stopping updating cells reference in excel formulas when I insert a row

    How can I disabling the update a reference cell in excel formula when I insert a row or a column.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    You could use named relative ranges.

  3. #3
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    You could also use the Indirect or Offset formulas, either in the formulas you're currently using or to create the named ranges. Note that Offset won't work for your requirements if you're talking about inserting a row above or a column to the left of the cell to be offset.
    For example, if you wanted to always sum A1:A10, you could use either =SUM(Indirect("A1:A10")) or =SUM(Offset(A1,0,0,10,1)).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1