how do I create a locked form to fill in the blanks

  • Thread starter Thread starter bill
  • Start date Start date
B

bill

how do I create locked form for filling in like name, address, date, etc,
somewhat like a fax form
 
Hi,

If you mean you want to use the sheet as a form but only allow entry in
certain cells, then select the cells you want unlocked and choose Format,
Cells, Protection, and uncheck Locked. Then choose Tools, Protection,
Protect Spreadsheet add a password or not, and unchieck Select locked cells
(or not).
 

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

Similar Threads

Auto fill not working 2
How do I create a form in Excel that I can send to be filled out? 2
Auto fill an address 1
Create Fillable PDF Forms With LibreOffice Writer 3
Word Macros in a Protected Word Document 0
Question about conditional formatting of zeros in Excel 0
fill in the blank form 1
Excel Can you lock the value of a cell but not the format? 1

Back
Top