how to block cells?

C

cgal

hi
i am trying to block cells. i'm writing a form and i want the empty
cells to blocked (in order that u can fill in only the cells you need
and you cant even click on the empty cells)
does anyone knows how to do that?

thanks
 
P

Peg

You can lock all cells except those you want available
for input. (format;cells; protection). Then protect the
sheet. In XP, you can allow the user to only select
unlocked cells. I don't know if that feature is
available in 2000; I don't think it was available in 97.
 
H

henry

Select the cell you want to block, go to format cell,
protection tab and select locked, as you can see this
protection has no effect unless the worksheet is
protected. choose protection from the tools menu, and
then choose protect sheet
 
Top