How can I prevent the use of delete key in a cell

  • Thread starter Excel doubt cleared
  • Start date
E

Excel doubt cleared

I want to get a warning message and prevent the null value in a cell when the
contents of a cell is deleted.
Please help as I am so tired in search for this.
Roby
 
D

Dave Peterson

I'd use an adjacent cell that was formatted in big bold red letters:

=if(a1<>"","","<-- Please enter something here!"
 
Top