We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

How to Insert a Tick Mark in Excel

Updated July 20, 2017

The Developer tab, hidden by default in Excel 2007 and 2010, contains a powerful array of tools, among them, the tick mark, or check box. Users can insert a tick mark as a Form control or an ActiveX control. For a simple check box that anyone can check or uncheck, with a label, a Form control is the simpler method.

Loading ...
  1. Reveal the Developer tab, if necessary. In Excel 2007, click the "Office" button and choose "Excel Options." In the Popular options set, check the box labelled "Show Developer tab in the Ribbon." In Excel 2010, click "File" then "Options." Choose "Customize Ribbon" in the Categories pane and check "Developer" in the list of tabs.

  2. Click the "Developer" tab. Choose "Insert" and from the Form Controls group choose the small box with a check mark in it.

  3. Draw a box with the cursor to define the location and size of tick mark and its label. These remain changeable.

  4. Click on the text, marked "Check Box 1," delete that text and add your own.

  5. Right-click anywhere in the form and choose "Format Control..." to set the form's formatting properties, such as colour and lines. Choose the "Control" tab to determine whether the box begins with a tick or without one. Add 3-D shading if you like.

  6. Tip

    In the Format Control dialogue box, if you set a cell link, checking the check box causes the word "TRUE" to appear in the linked cell; unchecking it causes the word "FALSE" to appear there instead. To edit any aspect of the control, right-click on it. Simply clicking on it will toggle the tick mark.

Loading ...

About the Author

Sonia Waring has been a professional technology editor since 1998, focusing primarily on software reviews and how-to articles. She also edits copy for scientific journals, several websites, and an independent network security consultancy.

Loading ...