Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

the hard but more convenient way is to give the default value in the first case and then copy them to all other vertical cells by using the cursor at the right hand corner till there is a cross and pull it down to the last cell. this is useful only in relatively small samples. very useful if you are calculating in the cell by applying a formula in the first cell. Smsv

share|improve this answer
This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review – Ramhound Jul 1 at 21:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .