JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,718
- Office Version
- 365
- Platform
- Windows
I came across a problem I often have with tables, or maybe it's the way I use tables. I often want to start a table with a constant and then perform some calculation, like adding 1, in each subsequent row, like this:
If I create the table with the constants in Row 1, then add the expressions in Row 2, they work, but they do not propagate. I have to manually drag the expressions down.
I just discovered a trick that gets around this. It I create the first 2 rows before converting it to a table, it works. Here it as a range:
Here it is after converting it to a table:
And here it is after I just tabbed to 3 new rows. They propagated automatically.



Any explanation why one works and the other doesn't?
If I create the table with the constants in Row 1, then add the expressions in Row 2, they work, but they do not propagate. I have to manually drag the expressions down.
Cell Formulas | ||
---|---|---|
Range | Formula | |
F5:G6 | F5 | =F4+1 |
I just discovered a trick that gets around this. It I create the first 2 rows before converting it to a table, it works. Here it as a range:
Cell Formulas | ||
---|---|---|
Range | Formula | |
C5:D5 | C5 | =C4+1 |
Here it is after converting it to a table:
Cell Formulas | ||
---|---|---|
Range | Formula | |
C5:D5 | C5 | =C4+1 |
And here it is after I just tabbed to 3 new rows. They propagated automatically.




Cell Formulas | ||
---|---|---|
Range | Formula | |
C5:D8 | C5 | =C4+1 |
Any explanation why one works and the other doesn't?