Updated on 08th Dec, 23 9.1K Views

In this blog, we will understand checkboxes in Excel, how they are used to make the data organized and efficient, and how to insert a checkbox in Excel. We will also look at the formatting of the checkbox in Excel. Finally, let us find out how to delete a checkbox in Excel when a particular checkbox is not required.

Table of Contents

Watch this video to learn more about Excel:

What is a Checkbox in Excel, and Why is It Used?

A checkbox in Excel is a form control that allows users to create interactive, clickable checkboxes within spreadsheets. They are visual elements that can be checked or unchecked with a click according to the user’s requirements. Checkboxes are generally used for creating to-do lists, data validation, interactive forms, or where you want a user to select from predefined options or mark the completion of a task.

Enroll in this Data Analytics Course and learn Excel from basic to advanced from experts.

How Do You Insert a Checkbox in Excel?

To insert a checkbox in Excel, we follow certain steps beginning with enabling the Developer tab in Excel.

Enable Developer Tab in Excel

1. Open Excel: Launch Microsoft Excel on your computer.

2. Access Options: Click on the File tab at the top-left corner.

3. Excel Options: Select Options at the bottom of the left sidebar.

As an alternative to these entire steps, we can right-click on the ribbon and select the Customize the Ribbon option, as shown in the image below:

4. Customize Ribbon: In the Excel Options dialog box, click on Customize Ribbon on the left sidebar.

5. Developer Tab: On the right side, you will see a list of Main Tabs for the Ribbon. Check the box next to Developer to enable it.

6. Save Changes: Click OK to save the changes and exit the Excel Options.

Insert the Data

When starting an Excel checklist or to-do list, the initial stage involves outlining a series of tasks or items intended for the insertion of checkboxes.

Example: We are taking an example of office routine, mentioning the sequence of events to be followed during the day.

Get 100% Hike!

Master Most in Demand Skills Now !

Insert a Checkbox 

To insert a checkbox in Excel, follow the given steps: 

Step 1: Go to Developer tab > Insert > Form Controls > Check Box

Step 2: Click in the cell where you want to insert the first checkbox.

Step 3: To remove or edit the text Check Box 11 (shown in the image), right-click the check box, select Edit Text in the context menu, and then delete or edit the text.

Copy Checkbox to other Cells

Click on the cell containing the checkbox using your keyboard’s arrow keys. Then, move the cursor to the lower right corner of the cell. Once the mouse pointer transforms into a slender black cross, pull it downward to the final cell where you intend to duplicate the checkbox.

After dragging them down, your checkboxes will look like this:

Ace your interview preparation and get yourself industry-ready. Go through these top Excel Interview Questions!

Career Transition

Intellipaat Job Guarantee Review | Intellipaat Job Assistance Review | Data Engineer Course
Got Job Promotion After Completing Artificial Intelligence Course - Intellipaat Review | Gaurav
How Can A Non Technical Person Become Data Scientist | Intellipaat Review - Melvin
Artificial Intelligence Course | Career Transition to Machine Learning Engineer - Intellipaat Review
Non Tech to Data Scientist Career Transition | Data Science Course Review - Intellipaat

We can capture the status as checked or unchecked of the check box by linking it to a cell.

Let us understand the steps to link a checkbox to a cell:

Step 1: Right-click on the checkbox and select Format Control.

Step 2: In the Format Control dialog box, implement the changes given below and then select OK.

  • Value: When you open the workbook, ensure that by default the checkbox is Checked.
  • Cell Link: $C$2. This is the cell linked to the checkbox. To obtain the reference, you can either manually enter it or choose the cell.

How to Format a Checkbox in Excel

To make the checkbox look more attractive, we can use formatting to give colors or other formats to the checkbox.

Follow the given steps:

Step 1: Right-click your checkbox and click Format Control.

Step 2: In the control dialog box, go to the Colors and Lines tab.

Step 3: Make the changes as per the requirements and click OK.

How to Delete a Checkbox in Excel

If a particular checkbox is no longer required, in that case, we can easily delete a checkbox in Excel with a few simple steps:

  • Go to Home > Find & Select > Go To Special
  • In the pop-up screen, check Objects and click OK
  • Checkboxes in Excel are viewed as objects, so all objects are selected that you want to delete. Now just press DELETE on the keyboard, and the checkbox is removed.

Conclusion

In conclusion, the checkbox in Excel is an important tool for tracking activities based on certain conditions. It can perform check/uncheck on the to-do list task to manage the records hence improving data management in Excel. 

Get all your doubts cleared by visiting our Community Page for Excel.

FAQs

How do I insert a checkbox in Excel?

  • Go to the Developer tab (if not visible, enable it in Excel Options > Customize  Ribbon).
  • Click on Insert in the Controls group and select Checkbox under Form Controls.
  • Click on the cell where you want to place the checkbox. A checkbox will appear.

Can I link a checkbox to a cell in Excel?

  • Right-click the checkbox, and select Format Control.
  • In the Control tab, link the checkbox to a cell by entering the cell reference in the Cell link box. The linked cell will show results (TRUE or FALSE) based on the checkbox status.

How can I copy a checkbox in Excel?

  • Select the checkbox you want to copy.
  • Hover over the border of the checkbox until the cursor becomes a four-headed arrow.
  • Hold down the Ctrl key and drag the checkbox to the desired location.

Can I resize a checkbox in Excel?

  • Right-click on the checkbox and select Format Control.
  • In the Size tab, adjust the Height and Width to resize the checkbox accordingly.

How do I delete a checkbox in Excel?

Right-click on the checkbox and choose Cut or Delete to remove it from the worksheet.

Course Schedule

Name Date Details
Data Scientist Course 02 Mar 2024(Sat-Sun) Weekend Batch
View Details
Data Scientist Course 09 Mar 2024(Sat-Sun) Weekend Batch
View Details
Data Scientist Course 16 Mar 2024(Sat-Sun) Weekend Batch
View Details

Leave a Reply

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

Speak to our course Advisor Now !

Related Articles

Subscribe to our newsletter

Signup for our weekly newsletter to get the latest news, updates and amazing offers delivered directly in your inbox.