Default value in a cell when adding a row
Solved
Brindeau
-
Brindeau -
Brindeau -
Hello,
I have a large Excel file where rows are automatically added whenever someone adds a row to the bottom. It automatically formats it like the rest of the table.
I would like it so that when someone adds a row, a default value appears in certain cells.
To have "standard track" displayed in my cell as soon as something appears in column A, I tried the formula:
=IF((ISBLANK($A1802));"";"Standard Track")
But if I place it in the cells below my table, the addition/formatting of new rows no longer works...
How can I maintain this automatic row insertion in my table while also adding a default value in certain columns?
(I also thought about using formula autofill but since the last row of my table doesn't necessarily contain the standard value, that isn't applicable)
Thank you very much for your help!
Configuration: Windows 7 / Chrome 40.0.2214.111
I have a large Excel file where rows are automatically added whenever someone adds a row to the bottom. It automatically formats it like the rest of the table.
I would like it so that when someone adds a row, a default value appears in certain cells.
To have "standard track" displayed in my cell as soon as something appears in column A, I tried the formula:
=IF((ISBLANK($A1802));"";"Standard Track")
But if I place it in the cells below my table, the addition/formatting of new rows no longer works...
How can I maintain this automatic row insertion in my table while also adding a default value in certain columns?
(I also thought about using formula autofill but since the last row of my table doesn't necessarily contain the standard value, that isn't applicable)
Thank you very much for your help!
Configuration: Windows 7 / Chrome 40.0.2214.111
3 answers
Hello,
Your table is a table created with 2007 and later versions.
To have an initial value in a column, you just need to put the formula in the new row:
It is possible to change the value, but the table keeps the formula for the next new row.
@The Penguin: a friendly good evening!
--
Always zen
Perfection is achieved not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
Your table is a table created with 2007 and later versions.
To have an initial value in a column, you just need to put the formula in the new row:
="Standard Track"
It is possible to change the value, but the table keeps the formula for the next new row.
@The Penguin: a friendly good evening!
--
Always zen
Perfection is achieved not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
I will test at the office starting tomorrow, thank you!