Ask Your Question

# Revision history [back]

### 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. 2 No.2 Revision oweng 21548 ●18 ●95 ●164

### 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. 3 No.3 Revision oweng 21548 ●18 ●95 ●164

### 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. 4 No.4 Revision oweng 21548 ●18 ●95 ●164

### 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.