Data Forms

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.

This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.