Specify a default value for a column in Datasheet view
You can specify a default value for columns of type single-line, choice, number, currency, or date and time. The default value will be shown automatically in the column for all new rows. You can leave the default value in the cell, or edit it any time.
- Right-click a column, and click Edit/Delete Column.
- Under Default Value, select one of the following:
- Text If the column type is Single line of text, specify a string as the default value.
- Choice If the column type is Choice, specify one of the choices from the list of choices you specified above.
- Number If the column type is Number, specify a numeric value.
- Currency If the column type is Currency, specify a currency value.
- Today's Date If the column type is Date and time, and you want the default value to be the current date, select this option.
- Any date If the column type is Date and time, and you want to specify a specific date, select the last option button, and enter a date in MM/DD/YYYY format.
- Yes in the Default value box If the column type is Yes/No (check box), and you want the check box to appear selected by default, select Yes.
- Calculated If you want to use a calculated value as the default value, enter a formula. Note that the formula cannot reference other columns in the list.