Unlock cells without values

  • Thread starter Thread starter Piotr
  • Start date Start date
P

Piotr

Hi
I do many files where I have to lock the cells for users,
Is there any way to make excell unlock every cell that is empty and
lock every cell which contains data or formulas in ?

regards
Piotr
 
Press F5 (Edit ->Go to) -> Special -> Blanks

Now, without changing the selection, unlock cells.

Note: This will select only those empty cells in the "used range".

If you want to unlock ALL the blank cells in the sheet, then, first
select all, unlock
then using the go to special, select formulae & constants and lock them

Hope this helps

~Yogendra
 
Back
Top