How to Use a Cell in Excel As a Checkbox

Written by ryan menezes
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Use a Cell in Excel As a Checkbox
Check boxes change cell data between two values (photo investment checkbox image by Aleksandar Radovanovic from Fotolia.com)

On a Word document, check boxes add to the page's design, visually representing an item's status. In Excel, they do more. Linking one to a cell lets you set the cell's value by checking or unchecking it. Spreadsheet formulas then use this changed data, determining other cells' contents. Excel hides this function by default. Enable it through the program's Developer tab.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    In Excel, click "File" from the menu bar.

  2. 2

    Click "Options" from the left pane. The "Excel Options" window will open.

  3. 3

    Click "Customize Ribbon" from the left pane.

  4. 4

    Check the box next to "Developer" in the "Customize the Ribbon" section on the screen's right side. Click "OK."

  5. 5

    Switch to the "Developer" ribbon.

  6. 6

    Click "Insert" from the "Controls" tab.

  7. 7

    Click the check box icon under "form controls." You cursor will turn into crosshairs.

  8. 8

    Click on the cell you want to change into a check box. A box will appear there.

  9. 9

    Drag the check box to align it with the cell. Change the box's label, which is "Check Box 1" by default.

  10. 10

    With the check box still selected, click "Properties" from the Developer ribbon's "Controls" tab. The "Format Control" window will open, with the "Control" tab selected.

  11. 11

    Enter the cell address in the "Cell link" box. Click "OK."

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.