Instructions to insert checkboxes in Excel

Microsoft Excel is a software that helps you track progress and make lists effectively, you can even insert checkboxes into spreadsheets.

You can just put an " x " in a column, but sometimes it's not professional. Instead, use the checkboxes to mark completed or unfinished items. Here's how to add checkboxes to Excel very simply.

Note: Excel Online does not support this function.

Step 1 : In Excel, find the Developer tab on the ribbon. If not, you can add it as follows:

Click File> Options> Customize Ribbon> check   Developer box > click OK in Excel 2010 and above.

In Excel 2007, click the Microsoft Office button and select Excel Options> Popular> Show Developer tab in the Ribbon .

Instructions to insert checkboxes in Excel

For Mac users, go to Excel Preferences and select Developer from the list in the View tab.

Step 2 : On the Developer tab, click Insert , then select the Checkbox icon .

Instructions to insert checkboxes in Excel

Mac users can click directly on the Check Box button .

Step 3 : In the spreadsheet, click the position you want to place the checkbox. You can start typing immediately to edit the default text after showing the checkbox, or right-click the checkbox to edit other features.

Instructions to insert checkboxes in Excel

Step 4 : The checkbox format options include Fill Color, Text Color, Borders, Other options (shown when you right click and select Format Control).

Instructions to insert checkboxes in Excel

Step 5 : Right-click to finish editing any checkbox; Left click to check or uncheck the box.

Create checklist in Excel with checkboxes

The checkboxes in the Developer tab only allow users to add checkboxes one by one. However, once there are several checkboxes on the page, you can select multiple checkboxes and use copy / paste to add more items to the spreadsheet faster.

To copy / paste checkbox:

  1. Right click the checkbox and select Copy .
  2. Right-click the location you want to place the copied checkbox and select Paste .
  3. You can right click the checkbox to edit text or format.

How to clear checkboxes in Excel

  1. Right-click the checkbox you want to delete.
  2. Select Cut .
  3. Do not paste the checkbox anywhere on the worksheet.

So you have created, customized and successfully deleted the checkbox in Excel already. Hope the article is helpful to you.

Sign up and earn $1000 a day ⋙

Leave a Comment

Why are horizontal tabs better than vertical tabs in browsers?

Why are horizontal tabs better than vertical tabs in browsers?

Vertical tabs are one of the most popular browser design trends, but not all new things are good. After trying vertical tabs in every browser imaginable, many people still stick with horizontal tabs.

Latest Legends of Speed ​​Codes and How to Enter Codes

Latest Legends of Speed ​​Codes and How to Enter Codes

Legends of Speed ​​codes are usually long-lasting. However, in some cases, they will have limitations such as entry limits or code time limits.

All the latest Loạn Dầu Chiến Binh giftcodes and instructions for redeeming codes

All the latest Loạn Dầu Chiến Binh giftcodes and instructions for redeeming codes

The Loạn Dầu Manga game code gives players general spins, diamonds, silver, gold, reward chests, valuable items...

Notepad is about to support automatic note summarization using AI

Notepad is about to support automatic note summarization using AI

This new feature is part of Notepad version 11.2501.29.0 update.

3 reasons why people keep using Netflix, despite its high subscription price

3 reasons why people keep using Netflix, despite its high subscription price

Netflix has raised its prices again and is now more expensive than ever. But many people don't plan on canceling their subscriptions anytime soon - here's why.

How to Create a Monochrome Color Effect in Photoshop

How to Create a Monochrome Color Effect in Photoshop

This tutorial will show you a quick and easy way to add a monochrome color effect to an image using Adobe Photoshop.

How to create a shadow border in Photoshop

How to create a shadow border in Photoshop

This tutorial will show you how to add canvas space and drop shadow to your photo in Photoshop to create a simple yet stylish photo border.

Advertising is making people use social media less

Advertising is making people use social media less

Ads are everywhere on social media, including between videos and short social media posts. And it’s these ubiquitous ads that are driving people away from social media platforms.

Configure Honkai Star Rail on your phone

Configure Honkai Star Rail on your phone

With the configuration of Honkai Star Rail on the phone, you will need to prepare a mid-range smartphone to be able to experience Honkai Star Rail on iOS and Android smoothly.

Latest Funtap Goddess Legend Code

Latest Funtap Goddess Legend Code

Let's explore the full set of giftcodes for Legend of Goddess - the game that has just been released.

Video: Close-up of the terrifying power of a super rocket that fired 100 arrows at once in the 15th century

Video: Close-up of the terrifying power of a super rocket that fired 100 arrows at once in the 15th century

What is Hwacha? This article will reveal to you what the Hwacha machine has that makes the Japanese army so afraid.

Close-up of the transformation process of the human body after death

Close-up of the transformation process of the human body after death

What are the stages after death? This article will reveal to you the process of body decomposition.

What is PAI on Mi Band 5? How to use PAI?

What is PAI on Mi Band 5? How to use PAI?

Since Mi Band 5, Xiaomi has added a PAI body index measurement feature. So what is this index? How to use it?

Latest Will of Hashira Code

Latest Will of Hashira Code

Code Will of Hashira is for those who are new to the game to get rewards, including money, gems, character summon tickets, hero experience...

The incompatibility of the systems in Pokemon GO

The incompatibility of the systems in Pokemon GO

When playing Pokemon Go, players need to pay attention to the problem of the conflicting systems to ensure their victory when fighting other Pokemon. This article will provide you with the full conflicting systems of different Pokemon, helping you ensure victory.