Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Expand references when new rows are inserted

I have not selected Expand reference when new rows are inserted still Calc expand cell references in sum formula here is an example:

I have a table as below:

| | A |

| 4 | Particulars | | 5 | 2 | | 6 | 3 | | 7 | 1 | | 8 | =sum(A5:A7) |

I am inserting 5 new rows with following steps: 1. Selecting cell aria A4 to A8 2. Right click on selected cell aria and press insert - entire row 3. Result is 5 new rows inserted and exiting table shifted below normally 4. But in sum formula at A13 =sum(A5:A12) auto cell reference expend happen and i have not enable this feature

It should not consider Expand reference in this case, normally 5 rows must be inserted with no formula change. This is general practice users copy the tables by inserting rows above or under the existing tables.

click to hide/show revision 2
No.2 Revision

Expand references when new rows are inserted

I have not selected Expand reference when new rows are inserted still Calc expand cell references in sum formula here is an example:

I have a table as below:

|      |         A           |

| -------------------------- | 4 | Particulars | | 5 | 2 | | 6 | 3 | | 7 | 1 | | 8 | =sum(A5:A7) |

|

I am inserting 5 new rows with following steps: 1. Selecting cell aria A4 to A8 2. Right click on selected cell aria and press insert - entire row 3. Result is 5 new rows inserted and exiting table shifted below normally 4. But in sum formula at A13 =sum(A5:A12) auto cell reference expend happen and i have not enable this feature

It should not consider Expand reference in this case, normally 5 rows must be inserted with no formula change. This is general practice users copy the tables by inserting rows above or under the existing tables.

click to hide/show revision 3
No.3 Revision

Expand references when new rows are inserted

I have not selected Expand reference when new rows are inserted still Calc expand cell references in sum formula here is an example:

I have a table as below:

|      |         A       |
--------------------------
|  4   |  Particulars    |
|  5   |         2       |
|  6   |         3       |
|  7   |         1       |
|  8   | =sum(A5:A7)     |

I am inserting 5 new rows with following steps: 1. steps:

  1. Selecting cell aria area A4 to A8 2. A8
  2. Right click on selected cell aria area and press insert - entire row 3. row
  3. Result is 5 new rows inserted and exiting table shifted below normally 4. normally
  4. But in sum formula at A13 =sum(A5:A12) auto cell reference expend happen and i have not enable this feature

It should not consider Expand reference in this case, normally 5 rows must be inserted with no formula change. This is general practice users copy the tables by inserting rows above or under the existing tables.

click to hide/show revision 4
No.4 Revision

Expand Why do references expand when new rows are insertedinserted above the summed range?

I have not selected Expand reference when new rows are inserted still Calc expand cell references in sum formula here is an example:

I have a table as below:

|      |         A       |
--------------------------
|  4   |  Particulars    |
|  5   |         2       |
|  6   |         3       |
|  7   |         1       |
|  8   | =sum(A5:A7)     |

I am inserting 5 new rows with following steps:

  1. Selecting cell area A4 to A8
  2. Right click on selected cell area and press insert - entire row
  3. Result is 5 new rows inserted and exiting table shifted below normally
  4. But in sum formula at A13 =sum(A5:A12) auto cell reference expend happen and i have not enable this feature

It should not consider Expand reference in this case, normally 5 rows must be inserted with no formula change. This is general practice users copy the tables by inserting rows above or under the existing tables.