+ Reply to Thread
Results 1 to 2 of 2

Inserting rows - does it break cell references?

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Office 365 Excel 2016

    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
    Tysons Corner, VA, USA
    MS-Off Ver

    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


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


    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.
    | | |會 |會 |會 |會 | |:| | |會 |會
    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


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