Excel Check Box Examples

The workbook shows how to make a checkbox in Excel and use the check box results in formulas to create an
interactive checklist, to-do list, report or graph.

Author
Last update
Tutorial URL

Examples:
• Excel checklist with data summary
• To-Do list example with conditional formatting
• To-Do list template with a graph
• Interactive report
• Dynamic chart depending on checkboxes' state
cel Check Box Examples
rkbook shows how to make a checkbox in Excel and use the check box results in formulas to create an
tive checklist, to-do list, report or graph.

Ablebits.com
18-Aug-16
How to insert checkboxes in Excel: interactive checklist, to-do list and report

hecklist with data summary

st example with conditional formatting
st template with a graph
tive report
c chart depending on checkboxes' state
Party Planning Checklist Done
Determine date and time ✘ FALSE
Determine theme FALSE
Create a guest list FALSE
Send invitations FALSE
Plan activities FALSE
Plan menu FALSE
Make shopping list FALSE
Clean the house FALSE
Set out decorations FALSE
Prepare food & drinks FALSE
Put my party clothes on FALSE

Total tasks 11
Completed tasks 0
% of Completed tasks 0.00%

Is everything good to go? Nope :(

To Do list Status Linked cells
Make beds ✘ To Be Done FALSE
Wash dishes To Be Done FALSE
Deal with the mail To Be Done FALSE
Do laundry To Be Done FALSE
Fix tires To Be Done FALSE
Pay electricity bill To Be Done FALSE
Get groceries To Be Done FALSE
Clean the house To Be Done FALSE
Check kids homework To Be Done FALSE
Walk the dog To Be Done FALSE

Total tasks 10
Completed tasks 0
% of Completed tasks 0%
 To Do list Total tasks:
Done: 0 out of 10 0% Tasks completed:

0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%

Tasks Status
Make beds ✘ ###
Wash dishes ###
Deal with the mail ###
Do laundry ###
Fix tires ###
Pay electricity bill ###
Get groceries ###
Clean the house ###
Check kids homework ###
Walk the dog ###
 Sales Report Checkbox
North
✘ North South East ✘ West Total $10,910 South
Average $303 East
West
Region Item Jul Aug Sep Sub-total Sub-average
West Apples $255 $340 $285 $880 $293
West Apricots $340 $320 $310 $970 $323
East Avocado $350 $250 $400 $1,000 $333
North Banana $280 $260 $335 $875 $292
North Blackberry $380 $290 $390 $1,060 $353
West Blueberries $340 $335 $295 $970 $323
South Cherries $295 $335 $250 $880 $293
West Coconut $340 $290 $390 $1,020 $340
South Cranberry $285 $280 $285 $850 $283
North Cucumber $335 $310 $280 $925 $308
South Currents $255 $280 $260 $795 $265
North Dates $340 $335 $335 $1,010 $337
East Figs $340 $280 $280 $900 $300
West Goldfinger $255 $295 $255 $805 $268
North Grapefruit $255 $255 $285 $795 $265
South Grapes $250 $285 $310 $845 $282
East Green apple $295 $310 $255 $860 $287
South Green banan $280 $310 $285 $875 $292
East Green grape $255 $285 $285 $825 $275
East Kiwi $335 $285 $335 $955 $318
South Lemon $250 $255 $280 $785 $262
West Lime $335 $420 $340 $1,095 $365
North Lychee $335 $340 $280 $955 $318
West Mango $285 $255 $340 $880 $293
North Melon $285 $335 $255 $875 $292
North Nectarine $285 $260 $250 $795 $265
East Orange $280 $335 $340 $955 $318
North Papaya $310 $285 $295 $890 $297
West Passion Fruit $285 $250 $255 $790 $263
West Peach $255 $335 $340 $930 $310
East Pear $340 $250 $255 $845 $282
West Pineapple $280 $285 $295 $860 $287
North Plum $295 $250 $255 $800 $267
East Pomegranat $285 $335 $310 $930 $310
North Pomelo $280 $310 $310 $900 $300
South Prunes $390 $335 $410 $1,135 $378
South Raspberries $285 $285 $295 $865 $288
West Red apples $280 $340 $255 $875 $292
South Strawberries $285 $250 $280 $815 $272
East Watermelon $255 $285 $340 $880 $293
East Yellow apple $255 $255 $335 $845 $282
West Yellow figs $255 $285 $295 $835 $278
North Yellow wate $295 $255 $295 $845 $282
Linked cell Region
0-
FALSE -
FALSE -
TRUE West
 Source data Linked cells Data for the chart
2013 TRUE
2013 2014 2015 2014 TRUE 2013 2014 2015
North $3,600 $3,485 $3,565 North $3,600 $3,485 $3,565
South $2,375 $2,615 $2,655 South $2,375 $2,615 $2,655
East $2,320 $2,870 $3,135 East $2,320 $2,870 $3,135
West $3,505 $2,750 $3,755 West $3,505 $2,750 $3,755

✘ 2013 ✘ 2014

$4,000

$3,000

$2,000

$1,000

$0
North South East West

2015 2013 2014