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 people starting to watch YouTube more on TV than on phones?

Why are people starting to watch YouTube more on TV than on phones?

People used to watch YouTube on their computers, then they mostly watched it on their phones. But today, when people think of YouTube, they think of TV.

Latest Code Thien Long Bat Bo VNG

Latest Code Thien Long Bat Bo VNG

Starting the game with the latest TLBB VNG giftcode rewards is the best way to make it easier for you at the beginning of the game.

How to share audio on TeamViewer

How to share audio on TeamViewer

With this audio sharing setup on TeamViewer, the other party can assist you in fixing the audio errors on the computer if there is a problem hearing the sound clearly from the computer.

A botnet just broke records with a massive 5.6Tbps DDoS attack

A botnet just broke records with a massive 5.6Tbps DDoS attack

A recent campaign set the record for the most powerful DDoS attack in history, generating 5.6 Tbps of data in a single session.

Microsoft 365 Personal and Home get price hike after Copilot and AI features added

Microsoft 365 Personal and Home get price hike after Copilot and AI features added

This will be the first price increase for Microsoft 365 Personal and Home subscriptions since Microsoft launched the Office 365 service 12 years ago.

Microsoft Outlook Contains a Critical Vulnerability That Could Easily Spread Malware

Microsoft Outlook Contains a Critical Vulnerability That Could Easily Spread Malware

Microsoft has just officially warned users about the existence of a vulnerability that could allow hackers to easily spread malware through the Outlook email application.

Accidentally discovered a drug that kills antibiotic-resistant bacteria in... home gardens

Accidentally discovered a drug that kills antibiotic-resistant bacteria in... home gardens

An international team of researchers has stumbled upon a new antibiotic called lariocidin, which has the potential to fight bacteria that do not respond to conventional drugs.

Admire the rare and beautiful astronomical ring of the universe

Admire the rare and beautiful astronomical ring of the universe

A new impressive image sent back from the world's most expensive space telescope, the James Webb Space Telescope, has captured a rare object called an Einstein ring.

Syndra DTCL season 8 equipment, equipment for Syndra Star Guardian

Syndra DTCL season 8 equipment, equipment for Syndra Star Guardian

Syndra DTCL season 8 has a simple skill and race but deals damage and stuns quite effectively.

Details about the Lien Quan badge system

Details about the Lien Quan badge system

The Lien Quan badge system has been updated from the battlefield version 3.0. Mastering the badge system will help you make better use of them in each match.

How can scammers exploit your social media profiles?

How can scammers exploit your social media profiles?

Social media is a prime target for scammers. By understanding their tactics, you can protect yourself from becoming a victim.

How to extract audio from video on iPhone

How to extract audio from video on iPhone

To separate audio from video on iPhone, you can use the shortcut to separate audio from video on iPhone with extremely simple implementation.

Tips to use Gemini assistant without unlocking your phone very quickly

Tips to use Gemini assistant without unlocking your phone very quickly

For more convenience when using Gemini, now we don't need to unlock the phone but can still use the Gemini assistant as usual.

Free tutorial for using Grok 3 chatbot

Free tutorial for using Grok 3 chatbot

Elon Musk's chatbot Grok now has a new version Grok 3 with fast response speed and natural language.

Ways to enable FPS in LMHT, enable Ping LOL

Ways to enable FPS in LMHT, enable Ping LOL

Ping and FPS are two indispensable indicators in the current League of Legends. Ping helps you control the game's latency, if the ping is high, you will definitely see your character slow down after your command.