How to create interactive check boxes in Excel, which can be linked to formulas, charts, conditional formatting and other features. Check boxes can be a great way to make your spreadsheets more visually appealing, user-friendly and efficient, allowing users to quickly select options and see the results of their selections in real-time. We'll walk you through the process step-by-step.
⏲ TIMESTAMPS
0:00 Interactive Excel Reports with Check Boxes
0:48 Check Box Task List
3:02 Status Bar Linked to Task List
4:48 IF formula linked to Check Box
6:37 Conditonal Formatting linked to Check Boxes
9:58 Charts Linked to Check Boxes