Alternatively, you can use the Ctrl + Shift + % keyboard shortcut. Use the Fill Handle to fill the empty cells. The attendance sheet in Excel for a ... checkboxes and Form Control checkboxes.