+ Reply to Thread
Results 1 to 2 of 2

Inserting rows - does it break cell references?

  1. #1
    Registered User
    Join Date
    03-20-2018
    Location
    Singapore
    MS-Off Ver
    Office 365 Excel 2016
    Posts
    62

    Inserting rows - does it break cell references?

    I have a project I was just about to submit when I realized I have to add a few rows to accomodate a new chart.

    Would this break the existing cell references and would I have to check every single one of these?

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,810

    Re: Inserting rows - does it break cell references?

    Excel is specifically designed so inserting rows does not break cell references.

    For example, if i have a formula

    =$A$13

    and I insert a new row at row 10, the formula will automatically change to

    =$A$14

    so it points to the same data that it did before, even though this is an absolute reference. (In fact, sometimes people do things where this normally-desired behavior is a problem, like when you always want to point to row 13 no matter how many rows get inserted above it.)

    Now that is a general answer, and I cannot answer that question about your specific file without being able to see A) your layout, and B) your formulas.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Inserting Formula to a cell from VBA using Array References
    By dougman824 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-16-2017, 11:02 PM
  2. Inserting Custom Headers based on cell value upon page break
    By WNErika in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-23-2013, 05:41 PM
  3. Not inserting cell references when navigating forms.
    By AnotherDaveC in forum Excel General
    Replies: 2
    Last Post: 04-11-2013, 10:32 AM
  4. Cell References Change When Inserting From Top Row
    By Bob McCusker in forum Excel General
    Replies: 1
    Last Post: 07-21-2010, 08:03 PM
  5. Inserting Text Cell References in Hyperlinks???
    By blackmejack in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2007, 02:52 PM
  6. Cell References When Inserting Rows
    By officeplus215 in forum Excel General
    Replies: 2
    Last Post: 09-30-2005, 09:05 PM
  7. Maintaining cell references when inserting cells elsewhere
    By Stephen Jefferson in forum Excel General
    Replies: 3
    Last Post: 08-05-2005, 05:05 PM

Tags for this Thread

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