ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Mandatory Cell Entry (https://www.excelbanter.com/excel-discussion-misc-queries/182541-mandatory-cell-entry.html)

Beep Beep

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

GoBow777

Quote:

Originally Posted by Beep Beep (Post 648289)
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

Dave Peterson

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


All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com