JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,643
- 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.![Thinking face :thinking: 🤔](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f914.png)
![Face with raised eyebrow :face_with_raised_eyebrow: 🤨](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f928.png)
![Thinking face :thinking: 🤔](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f914.png)
![Hushed face :hushed: 😯](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f62f.png)
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.
![Thinking face :thinking: 🤔](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f914.png)
![Face with raised eyebrow :face_with_raised_eyebrow: 🤨](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f928.png)
![Thinking face :thinking: 🤔](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f914.png)
![Hushed face :hushed: 😯](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f62f.png)
Cell Formulas | ||
---|---|---|
Range | Formula | |
C5:D8 | C5 | =C4+1 |
Any explanation why one works and the other doesn't?