How to Use Ticks in Excel

By Kathryn Hatashita-Lee

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.

Step 1

Open the Excel file.

Step 2

Click "Developer Tools" on the command ribbon.

Step 3

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

Step 4

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

Step 5

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

Step 6

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

Step 7

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

Step 8

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

Tips & Warnings

  • Try inserting the "+" symbol in the upper left corner of each cell. The column or row of check boxes will appear aligned on the worksheet.
  • If the Developer tab does not appear on the command ribbon, you can add this tab. Click the "File" tab. Click the "Options" button near the bottom of the list of commands. Click "Customize Ribbon." On the right side of the window, select "Main Tabs" in the text box in the "Customize the Ribbon" section. Select the check box for "Developer." The "Developer" tab and its commands appear on the command ribbon.