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

6 steps to wash shoes in the washing machine without worrying about damage

6 steps to wash shoes in the washing machine without worrying about damage

It seems like washing shoes in a washing machine is an absolute no-no, but with just 6 simple steps below, you can completely wash your shoes in a washing machine without worrying about damage.

9 reasons why the refrigerator is not freezing and how to fix it

9 reasons why the refrigerator is not freezing and how to fix it

There are 9 reasons why the refrigerator does not freeze. Our article below will summarize the common reasons and how to handle this situation.

Its time to switch to Passkey: The anti-phishing password alternative!

Its time to switch to Passkey: The anti-phishing password alternative!

With passkey, the modern alternative to traditional passwords, you won't have to worry about remembering, managing (with or without a password manager) or resetting your password ever again.

How to backup browser: Bookmarks, extensions, passwords, etc.

How to backup browser: Bookmarks, extensions, passwords, etc.

Whether you're switching browsers permanently or just want to reduce the chance of data loss, you need to back up your browser periodically.

Why do buffaloes and cows only need to eat grass to get enough nutrients?

Why do buffaloes and cows only need to eat grass to get enough nutrients?

Why do cattle eat grass and still get fat and produce nutritious milk? If you want to know why grass-eating animals get fat, please read the article below.

Supplements that people with irritable bowel syndrome should not take

Supplements that people with irritable bowel syndrome should not take

Not all supplements are beneficial for irritable bowel syndrome (IBS), some may even worsen your symptoms.

6 iMessage Apps for Group Chats

6 iMessage Apps for Group Chats

There are many iMessage apps for you to install for group chats, enhancing the experience with group members. Below is a list of 6 iMessage apps for group chats.

How to replace CMOS battery

How to replace CMOS battery

If your computer loses its time or date settings or displays a CMOS Read Error, CMOS Checksum Error, or CMOS Battery Failure message, the CMOS battery needs to be replaced.

Latest Super Beast Leader Code and how to enter code

Latest Super Beast Leader Code and how to enter code

Super Beast Leader Code will help you achieve attractive rewards to support players to become a super trainer. Below is the list of the latest Super Beast Leader codes and how to enter the code.

How to set Daikin air conditioner timer to turn on and off at desired time

How to set Daikin air conditioner timer to turn on and off at desired time

Daikin air conditioner timer is one of the useful features that users often use to set the timer to turn on the air conditioner before coming home or turn off the air conditioner while sleeping.

Why the timer on the washing machine is often wrong

Why the timer on the washing machine is often wrong

Most washing machines today have a display time and actual washing time difference of 10 to 20 minutes.

How to replace battery for Toshiba air conditioner remote control

How to replace battery for Toshiba air conditioner remote control

How to replace the battery for Toshiba air conditioner remote control? Please read the article below to learn how to replace the battery for Toshiba air conditioner remote control.

Summary of the latest Hero AFK: VNG Royal War codes

Summary of the latest Hero AFK: VNG Royal War codes

Entering the giftcode Hero AFK: VNG Royal War will help you receive many valuable ingame items. Let's explore now!

Latest Mini Heroes Dai Chien Tam Quoc Code

Latest Mini Heroes Dai Chien Tam Quoc Code

Code Mini Heroes Dai Chien Tam Quoc gives players money, diamonds and many other items such as general EXP, character EXP, Stamina, million soldier orders and many other attractive items.

5 Reasons to Try Google Gemini

5 Reasons to Try Google Gemini

While not as widely discussed as some of its competitors, Google's Gemini AI has a lot going for it — and here are five reasons why Gemini deserves your attention.