How to Create a Data Entry Form in a Very Easy Way | Gijis Channel



Community Tested

Why choose wikiHow?
When you see the green checkmark on a wikiHow article, you know that the article has received careful review. In this case, we tested the instructions on our own devices and confirmed that the instructions worked.

How to Create a Form in a Spreadsheet

Two Methods:

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.

Steps

Creating a Data Entry Form

  1. Open Excel.Click or double-click the Excel app icon, which resembles a white "X" on a dark-green background.
  2. ClickBlank workbook.It's in the upper-left side of the page.
  3. Add the "Form" button to Excel.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:
    • ClickFile.
    • ClickOptionsin the bottom-left side of the window.
    • ClickQuick Access Toolbaron the left side of the window.
    • Click the "Choose commands from" drop-down box at the top of the window.
    • ClickAll Commands.
    • Scroll down until you reachForm, then click it.
    • ClickAdd >>in the middle of the window.
    • ClickOK.
  4. Enter your column headers.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 cellA1, "Muffins" into cellB1, and so on.
  5. Select your column headers.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. Click the "Form" button.It's the box-shaped icon in the upper-left side of the Excel window, just right of the right-facing "Redo" button.
  7. Click when prompted.Doing so opens the Form pop-up window.
  8. Enter the data for your first row.Type whatever you want to add into each column header's text box.
  9. Click .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. Enter subsequent rows of information.Each time you finish filling out the data entry fields, clickingNewwill enter your data and start a new row.
  11. Close the data entry form.ClickCloseon the right side of the window to do so. Your data should now be completely entered below the appropriate column headers.

Creating a Custom Form

  1. Open Excel.Click or double-click the Excel app icon, which resembles a white "X" on a dark-green background.
  2. ClickBlank workbook.It's in the upper-left side of the page.
  3. Enable the Developer tab.TheDevelopertab 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:
    • Windows— ClickFile, clickOptions, clickCustomize Ribbon, check the "Developer" box, and clickOK.
    • Mac— ClickExcel, clickPreferences..., clickAuthoringunder the "View" heading, and clickDeveloper tab. You can then close the window.
  4. Enter your form's data.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. Click theDevelopertab.It's at the top of the Excel window.
  6. ClickInsert.This option is in the "Controls" section of theDevelopertoolbar. Clicking it prompts a drop-down menu to appear.
    • Skip this step on a Mac.
  7. Select a form control.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. Click anywhere on the spreadsheet.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. Right-click the form control icon.A drop-down menu will appear.
    • On a Mac, hold downControlwhile clicking the icon.
  10. ClickFormat Control….It's at the bottom of the drop-down menu.
  11. Edit your form control button.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. Click .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. Protect your spreadsheet.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— ClickReviewin the Excel toolbar, clickProtect 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 clickOK. You can then re-enter the password when prompted to finish locking the sheet.
    • Mac— ClickToolsat the top of the screen, selectProtection, clickProtect Sheetin 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 clickOK. You can then re-enter the password when prompted to finish locking the sheet.

Community Q&A

Search
Unanswered Questions
  • Can I incorporate a pull-down menu for each cell that is included on the Form? T
  • How do I create a spreadsheet form where accessibility is limited for certain sections?
  • How do I create a form that inputs data directly into another worksheet?
  • What help options are available to me when creating spreadsheets?
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.

Related wikiHows

Sources and Citations

Article Info

Categories:

In other languages:

Español: , Italiano: , Português: , Русский: , Deutsch: , Français: , Bahasa Indonesia: , Nederlands: , العربية: 

Thanks to all authors for creating a page that has been read 272,174 times.





Video: How to Create Registration Form in HTML - Easy Step

How to Create a Form in a Spreadsheet
How to Create a Form in a Spreadsheet images

2019 year
2019 year - How to Create a Form in a Spreadsheet pictures

How to Create a Form in a Spreadsheet forecasting
How to Create a Form in a Spreadsheet forecast photo

How to Create a Form in a Spreadsheet photo
How to Create a Form in a Spreadsheet picture

How to Create a Form in a Spreadsheet How to Create a Form in a Spreadsheet new images
How to Create a Form in a Spreadsheet new pictures

picture How to Create a Form in a Spreadsheet
photo How to Create a Form in a Spreadsheet

Watch How to Create a Form in a Spreadsheet video
Watch How to Create a Form in a Spreadsheet video

Communication on this topic: How to Create a Form in a , how-to-create-a-form-in-a/
Communication on this topic: How to Create a Form in a , how-to-create-a-form-in-a/ , how-to-create-a-form-in-a/

Related News


How to Improve Your Hearing
10 Amazing Short Hairstyles for Free-Spirited Women
Beef Stew Pasty
How to Download Free Music Videos With TuneGet
Maple Pumpkin Pie Buckwheat Groats
How to Calculate Bond Total Return
The Torrid Triangle
Why Youre Not a Failure if Your Relationship Ends
7 Popular Thanksgiving MythsDebunked
How to Use LINQ to SQL in C Sharp



Date: 10.12.2018, 22:51 / Views: 44431