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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top