Mandatory Cell Entry
 

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://office.microsoft.com/en-us/ex...CL100570551033

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

Mandatory Cell Entry
 

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!

Beep Beep wrote:

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

--

Dave Peterson