What a fillable form in Excel actually is

A fillable form in Excel is a spreadsheet where certain cells are set up so that someone can type into them, but other cells — the ones with instructions, labels, or calculations — stay locked and cannot be changed. When you send this form to someone else, they open it, fill in only the blanks you want filled, and send it back. The structure stays intact because the protected cells cannot be edited.

This is different from sending a regular spreadsheet, where the recipient could accidentally delete a formula, move a column, or change something you did not intend them to change. A fillable form prevents that by design.

Excel forms work best when you need to collect the same information in the same way from multiple people — a timesheet template, an expense report, a customer intake form, or a survey where the layout matters. If you need something more polished or want responses to go automatically into a database, Google Forms or Microsoft Forms are better choices. But if you already use Excel and your recipients do too, a fillable form is straightforward to set up.

Key Takeaways

  • A fillable form locks the cells you do not want changed and leaves only specific cells open for typing.
  • You create the form layout first, then select which cells should be editable, then protect the sheet.
  • Sheet protection in Excel is not a security feature — it is a convenience feature that stops accidental changes but can be removed without a password.
  • Test your form by opening it, trying to click on locked cells, and filling in the editable ones before you send it to anyone.
  • If you want to make changes to the form later, you unprotect the sheet, edit it, and protect it again.

Set up your form layout before you lock anything

Start by building the form the way you want it to look. Add your title at the top, create labels for each field, and leave blank cells next to or below each label where someone will type their answer. Use formatting — bold text, borders, background colors — to make it clear which cells are for input and which are instructions.

For example, if you are making an expense report, you might have "Employee Name:" in one cell and leave the cell next to it blank for typing. Below that, "Date:" with a blank cell. Then a table with columns for "Description," "Category," and "Amount," with empty rows below for the person to fill in.

Do not worry about protection yet. Just build the form so it looks and reads the way you want it. Include any formulas you need — like a sum at the bottom of an expense column — because those will be locked in place once you protect the sheet.

Save your file with a clear name like "Expense Report Template" or "Timesheet Form" so you know what it is when you open it later.

Select only the cells where people should type

Once your layout is done, you need to tell Excel which cells are allowed to be edited. The easiest way is to select all the blank cells where you want input — the ones next to the labels or in the table rows.

Click on the first blank cell. Hold Ctrl (or Cmd on a Mac) and click on each other blank cell you want to be editable. If you have a large range of cells, you can click the first one, hold Shift, and click the last one to select the whole range. You can also select multiple ranges this way — Ctrl+click to add more cells or ranges to your selection.

Once you have selected all the cells where typing should be allowed, right-click on one of them and choose "Format Cells." Go to the "Protection" tab. You will see a checkbox that says "Locked." Uncheck it. This tells Excel that these cells should not be locked when you protect the sheet. Click OK.

Now every other cell on the sheet — the labels, titles, and formulas — is still marked as locked. When you protect the sheet in the next step, those locked cells will be off-limits, and only the ones you just unlocked will accept typing.

Protect the sheet and test it

Go to the "Review" tab at the top of Excel. Click "Protect Sheet." A dialog box will appear asking if you want to set a password. You can leave this blank — the protection will still work, and anyone who opens the form can unprotect it if they really need to edit the structure. If you want to prevent casual editing, type a straightforward password and click OK. You will be asked to type it again to confirm.

Excel will tell you that the sheet is now protected. Close the dialog.

Now test the form. Try clicking on a cell that should be locked — like a label or a title. You should see a message saying the cell is protected. Try clicking on a cell you unlocked — it should let you type normally. Fill in a few test entries to make sure everything works the way you expect.

If you find a cell that should be editable but is not, or one that should be locked but is not, you need to unprotect the sheet, fix it, and protect it again. To unprotect, go back to the Review tab and click "Unprotect Sheet." If you set a password, you will need to type it. Make your changes, then protect the sheet again.

Send the form and collect responses

Once you are happy with how the form works, save it and send it to the people who need to fill it out. They can open it in Excel, fill in the blank cells, and save it with their information. When they send it back to you, you will have their responses in the exact format you designed.

If you want to collect many responses, you can ask people to save each completed form with a different name — like "Expense Report - John Smith" or "Timesheet - Week of Jan 15" — so the files do not overwrite each other when you save them all in one folder.

You can also create a master spreadsheet where you manually copy the responses from each form into a summary sheet, or use a macro to do it automatically if you are comfortable with that. For most small projects, though, collecting the individual files and reviewing them one by one is simpler.

Make changes to the form after it is protected

If you realize you need to add a field, change a label, or adjust a formula, you can edit the form even after it is protected. Go to the Review tab and click "Unprotect Sheet." Type your password if you set one. Make whatever changes you need — add rows, change text, update formulas. Then protect the sheet again the same way you did the first time.

If you have already sent the form to people and they have started filling it out, be careful about making structural changes. Adding a new field is usually fine, but deleting rows or moving columns might confuse people who are already working on their copies. If you need to make big changes, it is often better to create a new version of the form and ask people to use that going forward.

Frequently Asked Questions

Can I password-protect a fillable form so people cannot unprotect it?

Excel's sheet protection is not designed as a security feature. Anyone who knows how can unprotect a sheet, even with a password. If you need real security — to prevent someone from seeing or changing sensitive data — you should use a different tool or encrypt the file itself. For most forms, sheet protection is just to prevent accidental changes.

What if someone fills out the form and then cannot save it?

They should be able to save it normally. If they get an error, they may not have permission to save files to that location, or the file may be read-only. Ask them to save it to their desktop or a folder where they have write permission. If the form itself is read-only, right-click the file, choose Properties, and uncheck "Read-only" before sending it.

Can I use dropdown lists in a fillable form?

Yes. Create a dropdown by selecting a blank cell, going to the Data tab, clicking "Data Validation," and choosing "List." Type the options you want (separated by commas) or point to a range of cells that contains them. When someone opens the form, they can click that cell and choose from the dropdown instead of typing. This keeps responses consistent and reduces errors.

What happens if I send the form to someone who uses Google Sheets instead of Excel?

Google Sheets does not recognize Excel's sheet protection, so the form will open but the cells will not be locked. The person can edit anything. If you need to send forms to people using different tools, Google Forms or Microsoft Forms might be a better choice because they work the same way across platforms.

Can I make a fillable form that calculates totals automatically?

Yes. Add formulas to the cells where you want totals — like a SUM formula at the bottom of an expense column. When you protect the sheet, those formula cells will be locked so they cannot be changed, but they will still calculate based on what people type into the blank cells above them. This is one of the main reasons to use an Excel form instead of a static document.