A check mark box in an Excel spreadsheet is handy for ticking off items, but it can go much further. Excel check boxes can trigger calculations and provide visual indicators. For example, in ...

How to Convert True-False to Check Boxes in Excel. Microsoft Excel's form controls can turn the Boolean options of a true-false choice into a clickable data-entry option. If you create ...

Want to highlight Cell or Row if a checkbox is selected? We show you hHow to highlight a Cell or Row with a Checkbox in Excel.

Learn how to control Excel worksheets with spin buttons, scrollbars, option buttons, and checkboxes.

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.