📗 Free step-by-step guide

How to Make a Signup Sheet in Excel

Build a structured signup sheet in Excel with dropdown slots, a formatted table, and locked cells, then see where a spreadsheet still falls short for real signups and the faster free option.

How do you make a signup sheet in Excel?

To make a signup sheet in Excel, open a blank workbook and type column headers like Name, Slot, Email, and Phone. Optionally add drop-down time-slot lists with Data > Data Validation, then select your range and choose Home > Format as Table. Freeze the header row (View > Freeze Panes), then either print it or share it via OneDrive so others can type in their names.

Make a signup sheet in Microsoft Excel: step by step

The genuine, free way to do it right inside Microsoft Excel.

1

Open a blank workbook

In Excel, choose File > New > Blank workbook. In the top row, type your columns: Name, Time Slot, Email, Phone.

2

Add a dropdown of slots (optional)

Select the cells under “Time Slot,” go to the Data tab, choose Data Validation, set Allow to List, and type your options separated by commas.

3

Format it as a table

Select your headers and empty rows, then on the Home tab choose Format as Table (or Insert > Table). This adds filter buttons and auto-expands when someone adds a row.

4

Freeze the header row

Go to the View tab, click Freeze Panes, and choose Freeze Top Row so headers stay visible as the list grows.

5

Lock everything but the signup cells (optional)

Select the signup cells, right-click > Format Cells > Protection, and uncheck Locked. Then on the Review tab choose Protect Sheet.

6

Print or share via OneDrive

Use File > Print for a paper sheet, or save to OneDrive, click Share, and give people edit access so they can co-author it.

Where an Excel signup sheet falls short

Excel gives you structure - dropdowns, tables, and locked cells - but as a signup sheet it's still just a spreadsheet:

No automatic capacity limit or waitlist. Excel can't cap a slot at N people or queue overflow; Data Validation restricts what someone types, not how many people pick the same option.
Sharing requires edit access or emailing the file. For people to sign themselves up, you must save it to OneDrive and grant edit rights, or send the file out and merge replies by hand.
People can edit or delete each other's entries. Anyone with edit access can overtype or erase another person's row; Protect Sheet helps but doesn't give each person their own space.
No confirmation emails or reminders. Excel sends nothing automatically: no receipt to the signer, no nudge before the event.
Version conflicts. Emailed copies diverge into competing versions, and even co-authoring can hit sync issues if someone edits offline.

The faster alternative: a purpose-built signup sheet

If you want dropdown-style slots that actually enforce a limit - without OneDrive sharing headaches - a signup tool handles it natively. Grasshopper Signup is free and needs no account to start.

  • Set a limit on each slot and it fills, then locks, automatically - no add-on or script needed
  • Automatic waitlist: when a spot opens up, the next person is offered it
  • Confirmation and reminder emails go out to everyone who signs up
  • People sign up from a link in seconds - no account, no editing a shared file
  • See a live roster and headcount, exportable to CSV any time
  • Describe your event and AI builds the whole form in about 30 seconds
Create a Free Signup Sheet

Free, no account needed to start.

Microsoft Excel vs. a dedicated signup tool

Signup taskMicrosoft ExcelGrasshopper Signup
Cap each slot and close it automatically when fullNoYes
Automatic waitlist when a slot is fullNoYes
Automatic confirmation and reminder emailsNoYes
Shows remaining spots to people as they sign upNoYes
Keeps each person's entry private (no overwriting)NoYes

Microsoft Excel signup sheet FAQs

Select the cells you want to control, go to the Data tab, and click Data Validation. On the Settings tab, set Allow to “List,” then type your options in the Source box separated by commas or point to a range, and click OK. Each cell now shows a dropdown arrow.

Yes, if you save the workbook to OneDrive or SharePoint Online and share it with edit access. This is called co-authoring, and everyone sees changes in near real time. It requires a recent version of Excel; an emailed copy does not sync this way.

Not automatically. Data Validation controls what a person can type in a cell, but it doesn't count how many people have already chosen a slot or block the next one. You'd have to watch the sheet yourself, or build fragile helper formulas that still can't enforce a hard cap or run a waitlist.

Word is best for a printed sheet people sign by hand. Excel is better when you want structure, dropdown slot choices, filtering, and the option for people to type into a shared online copy. Neither enforces capacity limits, sends confirmations, or manages a waitlist.

Partially. Unlock only the cells people should fill (Format Cells > Protection > uncheck Locked), then use Review > Protect Sheet to lock the rest. This stops edits to headers and formulas, but it doesn't give each signer a private area; anyone with edit access can still change any unlocked cell.

Make a signup sheet in another tool

Google FormsGoogle DocsGoogle SheetsMicrosoft FormsWord

Or start with a ready-made signup sheet

Online Signup SheetsCreate a Signup SheetVolunteer Signup SheetsPotluck Signup SheetsAll Templates

Want slot limits a spreadsheet can't enforce?

No OneDrive edit-access juggling and no fragile formulas: create a free online signup sheet where each slot has a real cap and overflow goes to a waitlist.

Create Your Free Signup Sheet