How to Use Ticks in Excel

Employ Microsoft Excel 2010 to insert check boxes on a worksheet. You may want to include a column of check boxes if you have a list of items or steps. Anyone viewing the list can insert the check or tick in the check box beside the preferred item or completed step. The Developer tab on the command ribbon contains the check box command on a list of form control options.

...
Excel 2010 can create a list with check boxes that you can tick

Step

Open the Excel file.

Step

Click “Developer Tools” on the command ribbon.

Step

Click the down arrow on the “Insert” button in the “Controls” group. A list of controls appears.

Step

Click the “Check Box” button. This button displays a check mark inside of a square. The pointer changes to a “+” symbol.

Step

Click on the cell to place the check box. A square and the text “Check Box 1” display on the worksheet.

Step

Edit the text if desired. For example, delete “Check Box 1” and type an item or a step to compile a list.

Step

Click the text to insert a check or tick in the check box. To remove the check, click again on the text.

Step

Press "Ctrl" and "S" simultaneously to save the file.