Mandatory Cell Entry

[Beep Beep]

Is there a way in Excel to make it mandatory that individuals must fill out a
cell.

 

[GoBow777]

Is there a way in Excel to make it mandatory that individuals must fill
out a cell.

You can lock all the cells in a worksheet and unlock a select group of
cells so that only those cells can be selected, then apply Data
Validation to those select group of cells.

http://tinyurl.com/tt4t9

http://www.contextures.com/xlDataVal01.html

 

[Dave Peterson]

Not really.

I like to use an adjacent cell and just use a formula that nags the user until
the cell has something in it:

=if(a1<>"","","<-- Please fill in this cell!")

I'll format it in big red letters!