Input forms in Excel are an way to easily allow your users to add information to your spreadsheets. This comes in handy when using Excel as a database container for ordering, customer service, inventory or repair orders. But, input forms aren't just for business purposes. They can also be used in personal and academic Excel workbooks. Once you have set up your spreadsheet, adding input forms are fairly easy as long has you have some basic knowledge of using Excel.
- Skill level:
- Moderately Easy
Other People Are Reading
Plan your worksheet. Think about the type of information you will be keeping in the spreadsheet and set up your columns.The column headers will be used as the form labels next to the input boxes.
Set up your spreadsheet. Type in the column headers. Set the column lengths. Do not merge any cells in the column headers. Excel will not be able to generate an input form from merged cells. You can always make the columns bigger by changing the column width property.
Add the Form button to the Quick Access toolbar. Click the drop-down arrow on the Quick Access toolbar and then click "More Commands." A dialogue box appears. Click the drop-down under "Choose commands from:" and choose "All Commands." Stroll through the list and find "Form." Highlight "Form" and click "Add," then click "OK." The Form button is now in your Quick Access toolbar.
Highlight the column headers. Click on the "Form" button in the toolbar. Excel will generate an input form that will allow you to enter in new information into the columns. Notice your column headers on the left-hand side of the input form next to the text boxes.