data entry validation
 

i have a spreadsheet with two columns containing text data, one column
containing date data, and ten columns containing either number or currency
data. currently i only have 100 rows with data.
my goal is when i enter data in a row NOT to have blank text and date cells
and number and currency cells to have a value equal or greater than zero.
is that possible in excel?

data entry validation
 

Try using the data validation tool. Data Validation

There you can set what data is allowed where.

"angie" wrote:

i have a spreadsheet with two columns containing text data, one column
containing date data, and ten columns containing either number or currency
data. currently i only have 100 rows with data.
my goal is when i enter data in a row NOT to have blank text and date cells
and number and currency cells to have a value equal or greater than zero.
is that possible in excel?