How to create Checkboxes in 28 seconds ✅ #excel

In this video, you will learn how to create checkboxes in Excel!

Step 1. Go to Insert tab.
Step 2. Click Checkbox.
Step 3. Fill checkboxes to the right and down.
Step 4. Check off boxes.
Step 5. In the adjacent column, type in the formula =COUNTIF(C4:G4, TRUE)/COUNTA(C4:G4)
Step 6. Copy the formula down as necessary.

If you're not using Excel Dashboards to save you hours each week - you're missing out! In Miss Excel's FREE Class, she will show you her top tips for optimizing your spreadsheets.

Register using the link on our channel page!

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials