# 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.

• 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.)