Fill-in Form

M

M Davis

I am trying to build a fill-in form with some of the
cells protected. I am unable to find out where to
protect just a few cells at a time and not the entire
worksheet? Example: Date:___________ -- the date would
be protected and the line would be the fill-in...

Thanks.
 
P

PTT, Inc.

What you do is to select the cells you want to be able to "fill-in", click
"Format", "Cells", click the "Protection" TAB, then uncheck the locked
option. Then click "Tools", "Protect worksheet". Since those cells are not
locked you can enter data in them. By the way, you can hold down the CTRL
key and click on all cells to do this once!

Bill Foley
www.pttinc.com
 
Top