Smokeyham
Board Regular
- Joined
- Feb 1, 2006
- Messages
- 120
- Office Version
- 365
- Platform
- Windows
Hello,
I have a table with a number of calculated columns. I would like to change the formula in one column, and want to keep the formula for the previous entries, but when I enter a new row (which automatically expands the table) then I would like the new formula to be the default which is filled in automatically.
When I try this with the new formula in the row above, the old formula is automatically filled into the new row and I have to copy my new formula from the row above and paste it into the cell.
Any thoughts on how I change the default?
Thanks!
I have a table with a number of calculated columns. I would like to change the formula in one column, and want to keep the formula for the previous entries, but when I enter a new row (which automatically expands the table) then I would like the new formula to be the default which is filled in automatically.
When I try this with the new formula in the row above, the old formula is automatically filled into the new row and I have to copy my new formula from the row above and paste it into the cell.
Any thoughts on how I change the default?
Thanks!