Excel provides data forms as a useful tool for quickly editing a data list. If you have a large amount of data, you do not necessarily have to edit information in your cells directly. Use the following articles to learn how to use data forms in Excel.
Tips, Tricks, and Answers
The following articles are available for the 'Data Forms' topic. Click the article''s title (shown in bold) to see the associated article.
Independent Radio Buttons
Radio buttons are great for some data collection purposes. They may not be that great for some purposes, however, for the reasons described in this tip.
Protecting Formulas in Control-Linked Cells
Form controls can be a great way to get information into a worksheet. They are designed to be linked to a cell so that the cell reflects the current state of the control. This means, however, that form controls can be destructive if you have something else (such as a formula) in the linked cells. This tip looks at ways you can get around this destructive behavior.
Using Data Forms
Lots of people prefer to enter information directly into Excel, but there is another way that may be helpful: Using data forms. This tip introduces data forms, explains how to display them, and shows how easy it is to use them for editing your data.
Using List Box Controls
List boxes can be a great tool for getting input from users of your worksheets. This tip describes what list boxes are and how you go about using them.