Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
Is this default value the same for every row? Or does it vary based on the contents of the row? – DMA57361 Sep 17 '10 at 9:05

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.


  • 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.
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.