QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Insert Checkbox in Excel?

By Neha T Leave a Comment

Do you want to insert a checkbox in Excel? A checkbox is a small square box that can be checked or unchecked depending on the condition. You might have seen this checkbox in many of the forms that you fill online, it is quite interactive as it easily allows you to select and deselect the option.

Let us learn how you can insert a checkbox in the cell of the excel sheet. Along with this, we will also cover:

  1. Activate Developer Tab
  2. Insert a Checkbox
  3. Edit Checkbox
  4. Insert Multiple Checkbox
  5. Link a Checkbox to a Cell

Steps to Insert the Checkbox in Excel:

Activate Developer Tab

If you do not have the developer tab then you have to activate it. To activate the developer tab, you have to right-click on the Ribbon and from the displayed menu click on ‘Customize the Ribbon…’ as you can see in the image below.

Insert Checkbox in Excel - 1

Insert a Checkbox

Step 1: Suppose I have a list of groceries and I have to add a checkbox in front of each grocery item then just click on the cell where you want to add the checkbox.

Insert Checkbox in Excel - 2

Step 2: Now go to the ‘Developer’ tab and in the ‘Controls’ group click on the ‘Insert’ dropdown button.

Insert Checkbox in Excel - 3

Step 3: The Insert drop-down menu displays many control buttons from which you have to click on the checkbox you can see in the image below:

Insert Checkbox in Excel - 4

Step 4: Now after selecting the checkbox from the Insert button, where ever you will click on the excel sheet it will create a checkbox over there. If it doesn’t lie at its proper place then you can easily drag and drop it to its proper place.
Insert Checkbox in Excel - 5

Edit Checkbox

Step 1: Hover your mouse over the checkbox and click on it to select it. Now right click on the checkbox and from the displayed option you have to click on the ‘Edit Text’.

Insert Checkbox in Excel - 6

And you can simply add another text instead of ‘Check Box 1’ or simply delete all the text and let the square checkbox all alone.

Insert Multiple Checkbox

To insert the multiple checkboxes at once just simply select the cell with the checkbox and from the right bottom of the cell drag it down or vertically or horizontally to copy the checkbox.
Insert Checkbox in Excel - 7

Link a Checkbox to a Cell

Step 1: Click on the checkbox to select it. Now right click on the checkbox and from the displayed options you have to click on ‘Format Control…’.

Insert Checkbox in Excel - 8

Step 2: A Format Control window will pop up where you have to go to the Control tab. Now in the Value section, you have to select the value of the checkbox as ‘checked’ and then you have to mention the cell that you want to link to the cell containing the checkbox. Now click OK to confirm the settings.

Insert Checkbox in Excel - 9

If you have checked the checkbox then the linked cell will display TRUE value and if the checkbox is unchecked then the linked cell will display FALSE value.

So, this is all about how you can insert, edit, link or duplicate the checkbox in excel.

You Might Also Like:

how-to-insert-clickable-checkbox-in-ms-word-2016How to Insert Clickable Checkbox in MS Word 2016? Hide Formula in Excel - feature imageHow to Hide Formula in Excel? Lock Formulas or a Cell in Excel - feature ImageHow to Lock Formulas or Cells in Excel? How to Concatenate in Excel -featured imageHow to Concatenate Multiple Cells in MS Excel 2016? How to convert text to number in Excel - Featured ImageHow to Convert Text to Number in MS Excel 2016? Merge Cell in Excel feature imageHow to Merge Cells, Columns & Rows in Excel? how-to-break-links-in-ms-excel-2016-featured-imageHow to break Links in MS Excel 2016? how-to-split-text-of-cells-in-ms-excel-2016-featured-imageHow to Split Text in a Cell in MS Excel 2016?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to disable Screen Saver in Windows 7?
  • How to add page numbers to PDF
  • How to Calculate Average in Excel?
  • How to Disable Comments on a Specific Page in Wordpress
  • How to Change a File Extension in Windows 10?

Copyright © 2022 · QueHow · Contact Us