For example, if you have a check box in cell A1, you can use a formula like =IF (A1, "Checked", "Unchecked") to display a custom message based on the check box's state.

You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.

You can easily insert a check mark (also known as a "tick mark") in Word, Outlook, Excel, or PowerPoint. These marks are static symbols. If you're looking for an interactive check box that …

Add a list box to your Excel worksheet from which users can choose a value. Make data entry easier by letting users choose a value from a combo box. A combo box combines a text box …

Use a custom list to sort or fill in a user-defined order. Excel provides day-of-the-week and month-of-the year built-in lists, but you can also create your own custom list.

You can quickly create a named range using the currently selected range in your Excel worksheet.

Create a list based on an Excel (.xlsx) file There are different ways to start a list from an Excel file. You can go to the Lists app in Microsoft 365, SharePoint, or Teams. Choose an app to start …

You can create a form in Excel by adding content controls, such as buttons, check boxes, list boxes, and combo boxes to a workbook. Other people can use Excel to fill out the form and …

With multiple-selection list boxes, users make choices by selecting or clearing check boxes in a box on the form. If the number of check boxes exceeds the height of the control, a scroll bar …

Click the arrow in the column header to display a list in which you can make filter choices. To select by values, in the list, clear the (Select All) check box. This removes the check marks …