How To Add a Checkbox in Excel (In-Cell Checkbox)

Learn the simplest way to add a checkbox inside a cell in simple and easy steps.

Whether you want to create a to-do list, track tasks, manage attendance, build dashboard controls, design input forms, conduct surveys, track inventory, or manage project status, the checkboxes are what you need. They make it easy to represent simple yes/no or true/false decisions directly inside your worksheet. You don’t need fancy data validation or dropdown menus.

In this quick and easy guide, I will show you how to add in-cell checkboxes in Excel and how to remove them when not needed. Let’s get started.

Before You Start

• The steps below will only work in Microsoft 365. The older versions (2016, 2019, 2021) don’t support in-cell checkboxes.

Steps to Add Checkboxes in Excel

1. Open the Excel workbook.
2. Select the cells, column, or rows in which you want to add checkboxes.
3. Go to the “Insert” tab on the top ribbon menu.
4. Select the “Checkbox” option.
5. With that, you’ve added checkboxes in Excel.

Detailed Steps (With Screenshots)

To start off, open the Excel workbook when you want to add the checkboxes. You can do it by double-clicking the Excel file. Alternatively, open Excel by searching for it in the Start menu, then select the document/workbook under the “Recent” section.

Once the workbook opens, select the cells where you want to display checkboxes. You can also select entire columns or rows. Next, go to the “Insert” tab on the top ribbon menu and then click the “Checkbox” option.

That is all. Excel instantly adds checkboxes to all the selected cells, columns, or rows. You can increase or decrease the size, change the color, and change the alignment using the font and alignment options under the “Home” tab.

Steps to Remove Checkboxes in Excel

You cannot simply click the “Delete” key on your keyboard to delete the checkboxes. Here’s how to do it properly.

1. First, select the cells, rows, or columns that contain the checkboxes you want to delete.
2. Go to the “Home” tab.
3. Click the “Eraser” icon in the “Editing” section.
4. Select the “Clear all” option.
5. That deletes the selected checkboxes in the Excel sheet.

—

That is all. It is that simple to add checkboxes in Excel. If you have any questions or need help, comment below. I’ll be happy to assist.