Excel – Set default cell value in Excel

microsoft-excel-2007

Other than the top row, which is a header, I'd like one column to always have a default value, ideally added when that row is not empty… so I don't have an infinite number of rows with just the default value.

I couldn't find a way to set default values at all – I do not want the user able to edit this.

Best Answer

  • You can fill that column with formula =IF(D4="";"";"default value"), assuming you're in row 4 and column D will be filled in later on.  (Use =IF(D4="","","default value") if your version of Excel separates function arguments with commas.)

    Translation:

    • If the row 4 is not filled in, then the result is blank so nothing is shown.
    • If the row 4 is filled and the user has entered a value in column D, then your default value is shown.
    • The user can fill in any other value instead of this formula, thereby simply overwriting the formula which isn't needed anymore anyway.
    • You can protect the column if you don't want the user to overwrite your default value.
  • Related Question