How to block empty cells within excel?

**toplisek** · 02-10-2010, 10:06 AM

I enclose sample excel file. I like to block empty cells that user can not make mistakes. How to do it?

**Richard Buttrey** · 02-10-2010, 10:12 AM

Hi,

It's not clear how you are defining empty cells, but the way to protect cells from entry is to switch on sheet protection Tools>Protection>Protect Sheet. If you have certain cells in which you want the user to be able to enter information the make sure you unlock those first. i.e. Format>Cells>Protection and untick the 'Locked' box.

HTH

**toplisek** · 02-10-2010, 10:16 AM

I like to block users that receive this excel to change any my blocked (blank) defined fields.
Like area outside editable fields...

**Richard Buttrey** · 02-10-2010, 10:53 AM

Hi,
Have you unlocked the cells which you are happy for users to change and protected the worksheet as suggested?

Rgds

**toplisek** · 02-10-2010, 03:09 PM

I will test

**toplisek** · 02-11-2010, 02:40 AM

Hi,
I have tried but have issue.
I checked Protect WorkSheet and choices in Office Pro 2007:
1. Choice Locked Cells
2. Choice Unlocked Cells

How to define which will be locked and which Unlocked?
I have first defined Unlocked cells and button changed to Remove protection
How to define than with password all other cells?