PDF download Download Article
A quick and easy guide to create forms in Microsoft Excel
PDF download Download Article

This wikiHow teaches you how to create a form in a Microsoft Excel document. A spreadsheet form allows you to enter quickly large amounts of data into a table or list of cells. If you want to create a form with which other people can interact, you can use options found on the Developer tab of Excel to do so. Keep in mind that the data entry form feature is only available in Excel for Windows computers.

Method 1
Method 1 of 2:

Creating a Data Entry Form

PDF download Download Article
  1. Click or double-click the Excel app icon, which resembles a white "X" on a dark-green background.
  2. It's in the upper-left side of the page.
    Advertisement
  3. By default, the "Form" button isn't included in Excel. You can add it to Excel's list of "Quick Access" icons that appear in the top-left corner of the window by doing the following:
    • Click File .
    • Click Options in the bottom-left side of the window.
    • Click Quick Access Toolbar on the left side of the window.
    • Click the "Choose commands from" drop-down box at the top of the window.
    • Click All Commands .
    • Scroll down until you reach Form , then click it.
    • Click Add >> in the middle of the window.
    • Click OK .
  4. Type the name of the column into which you want to add data into the top cell in each column you want to use.
    • For example, if you're creating a form that lists different baked items, you might type "Pumpkin Bread" into cell A1 , "Muffins" into cell B1 , and so on.
  5. Click and hold the left-most column header, then drag your mouse right to the right-most column header. You can then release your mouse button.
  6. It's the box-shaped icon in the upper-left side of the Excel window, just right of the right-facing "Redo" button.
  7. Doing so opens the Form pop-up window.
  8. Type whatever you want to add into each column header's text box.
  9. It's in the upper-right side of the pop-up window. Doing this will automatically enter your typed data into the spreadsheet under the appropriate column headers.
  10. Each time you finish filling out the data entry fields, clicking New will enter your data and start a new row.
  11. Click Close on the right side of the window to do so. Your data should now be completely entered below the appropriate column headers.
  12. Advertisement
Method 2
Method 2 of 2:

Creating a Custom Form

PDF download Download Article
  1. Click or double-click the Excel app icon, which resembles a white "X" on a dark-green background.
  2. It's in the upper-left side of the page.
  3. The Developer tab is where you'll find the option to insert form buttons, but it isn't included in Excel by default. To enable it, do the following: [1]
    • Windows — Click File , click Options , click Customize Ribbon , check the "Developer" box, and click OK .
    • Mac — Click Excel , click Preferences... , click Authoring under the "View" heading, and click Developer tab . You can then close the window.
  4. Type in whatever data you want users to be able to select in your form.
    • This step will vary depending on the information you want to use in your form.
  5. It's at the top of the Excel window.
  6. This option is in the "Controls" section of the Developer toolbar. Clicking it prompts a drop-down menu to appear.
    • Skip this step on a Mac.
  7. Click the type of control you want to use for your spreadsheet.
    • For example, if you want to add a checkbox to your form, you would click the checkbox icon.
  8. Doing so will place your control button on the spreadsheet.
    • You can click and drag your control to the location in which you want to anchor it.
  9. A drop-down menu will appear.
    • On a Mac, hold down Control while clicking the icon.
  10. It's at the bottom of the drop-down menu.
  11. Depending on the button you selected, your options will vary; in most cases, you'll be able to select a cell range or a target cell by clicking the arrow to the right of the "Cell range" or "Target cell" text box and then selecting cells (or a cell) that contain your form's data.
    • For example, if you wanted to create a drop-down menu with a list of numbers, you would click the arrow to the right of the "Cell range" text box and then click and drag your mouse down a column of numbers in your spreadsheet.
  12. It's at the bottom of the window. Doing so saves your settings and applies them to your spreadsheet.
    • At this point, you can proceed with adding other form buttons to your spreadsheet.
  13. Once you've finished adding form buttons to your spreadsheet, you can prevent people from moving or removing the buttons by protecting the spreadsheet:
    • Windows — Click Review in the Excel toolbar, click Protect Sheet , make sure that any options other than "Select locked cells" and "Select unlocked cells" are unchecked, enter a password to unlock the document, and click OK . You can then re-enter the password when prompted to finish locking the sheet.
    • Mac — Click Tools at the top of the screen, select Protection , click Protect Sheet in the pop-out menu, make sure that any options other than "Select locked cells" and "Select unlocked cells" are unchecked, enter a password to unlock the document, and click OK . You can then re-enter the password when prompted to finish locking the sheet.
  14. Advertisement

Expert Q&A

Ask a Question
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Thanks for submitting a tip for review!

      About This Article

      Article Summary X

      1. Open a blank workbook.
      2. Add the "Form" button to Excel.
      3. Create column headers.
      4. Select the column headers.
      5. Click Form .
      6. Click OK .
      7. Enter the first row data and click New .
      8. Enter additional rows. 9. Click Close .

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 457,282 times.

      Reader Success Stories

      • Anonymous

        Jul 17, 2016

        "I was trying to manually make a worksheet that could act as a form. I had no idea Excel had a hidden ..." more
      Share your story

      Is this article up to date?

      Advertisement