• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Insert Check Box in Excel

June 21, 2021 by Andrew Childress
Insert check box in Excel

Excel spreadsheets help you build interactive forms. These often include check boxes that users can click on. Here's how to insert check boxes in Excel.

Excel spreadsheets help you build interactive forms. These often include check boxes that users can click on. Let’s learn how to insert check boxes in Microsoft Excel.

How to Insert Check Boxes in Excel

An interactive check box helps users specify selections in spreadsheets that you share with them. To add a check box in Excel, you’ll be working in an area of the app called the Developer tab.

By default in Excel, the Developer tab isn’t automatically displayed. That means you’ll need to activate it in order to make use of its tools. To get started, click on the Excel dropdown in the upper left corner of your screen. From there, click Preferences.

Check box Excel

This is a dashboard listing an array of Excel layout and customization options.

Click on Ribbon & Toolbar, then scroll down the list on the right side of the menu that appears. The option you want is Developer. Click on the box beside it, and finish by clicking Save.

Insert check box in Excel

You’ll now see the Developer tab appear on Excel’s ribbon. Typically, it will be placed immediately to the right of the existing View tab.

Click on Developer to open it up. You’ll see an array of options: combo box, label, and of course, Check Box, among many others. To add a check box, click on Check Box.

Add check box to Excel

Hover over your spreadsheet, and you’ll see that your cursor has become a + symbol. Click once, and you’ll see an interactive check box appear on the sheet in the spot where you clicked.

Insert check boxes in Excel

By default, Excel names the box Check Box 1. However, the title works like any text box. You can easily replace the default title with words of your own.

As you can see, it’s easy to check and uncheck by clicking repeatedly. Excel makes it simple to insert check boxes to build amazing interactive spreadsheets quickly.

Category: Examples, Excel ShortcutsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Create chart in ExcelChart in Excel
Next Post:Count in ExcelCount in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top