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

Zooper Widget for Android 2.36 - Latest Version Updates for 2024 and 2025

Zooper Widget for Android 2.36 - Latest Version Updates for 2024 and 2025

Discover the latest updates in Zooper Widget for Android. Zooper Widget is a compact, highly customizable, and battery-friendly widget with endless possibilities.

Lipp for iOS 4.4 - Make lip sync and voiceover videos on iPhone / iPad 2024, 2025

Lipp for iOS 4.4 - Make lip sync and voiceover videos on iPhone / iPad 2024, 2025

Lipp for iOS, alongside Dubsmash and Musical.ly, provides iPhone and iPad users with a new platform to create lip sync videos and dub videos readily.

How to Share Audio with TeamViewer - Latest Version Updates 2024, 2025

How to Share Audio with TeamViewer - Latest Version Updates 2024, 2025

Learn how to share audio using TeamViewer, including the latest updates for 2024 and 2025, making remote communication more effective.

Adorable Home: Latest Tips for Petting Your Cat in 2024 and 2025

Adorable Home: Latest Tips for Petting Your Cat in 2024 and 2025

Learn the latest tips on how to pet a cat in Adorable Home for optimal gameplay in 2024 and 2025. Discover what positions give you hearts.

OrangeHRM Open Source 3.2.1 - Latest Features for 2024 and Beyond

OrangeHRM Open Source 3.2.1 - Latest Features for 2024 and Beyond

Explore the latest features of OrangeHRM Open Source, a free HR management system tailored to meet evolving business needs in 2024 and 2025.

How to Fix IDM Error Not Catching Download Links - Updates for 2024 and 2025

How to Fix IDM Error Not Catching Download Links - Updates for 2024 and 2025

Fix IDM not catching file download links. Discover solutions for downloading videos, music, and more with the latest IDM updates in 2024 and 2025.

The File Converter for Android - Convert files to other formats - Updated Versions 2024, 2025

The File Converter for Android - Convert files to other formats - Updated Versions 2024, 2025

Discover the latest version of The File Converter for Android, an application that converts various file formats efficiently.

Updated Zalo Web Login Features for 2024-2025

Updated Zalo Web Login Features for 2024-2025

Explore the latest features of Zalo Web, allowing users to chat and connect seamlessly on various browsers without installation.

PDF Password Remover 6.0 - The Ultimate Solution for Password Removal in PDF Files

PDF Password Remover 6.0 - The Ultimate Solution for Password Removal in PDF Files

PDF Password Remover is a powerful tool for removing passwords and restrictions from PDF files. Download the latest version for 2024 to experience enhanced features.

Latest Instructions for Completely Removing Internet Download Manager (IDM) - Updated for 2024 and 2025

Latest Instructions for Completely Removing Internet Download Manager (IDM) - Updated for 2024 and 2025

Step-by-step instructions to completely remove Internet Download Manager (IDM) from your system in 2024 and 2025. Learn to uninstall IDM effectively and cleanly.

Mindjet MindManager 2024 & 2025 - Empower Your Mind Mapping

Mindjet MindManager 2024 & 2025 - Empower Your Mind Mapping

Discover Mindjet MindManager, an innovative software that helps individuals and teams streamline their work processes through effective mind mapping and project management.

Su Doku 2.0.0 - Latest Updates 2024 & 2025

Su Doku 2.0.0 - Latest Updates 2024 & 2025

Su DoKu 2.0.0 is an advanced Sudoku game design software that captivates enthusiasts with its simplicity and functionality. Download now and challenge yourself with Sudoku puzzles.

Google Photos for Android - Unlimited Photo and Video Storage with Latest Features in 2024, 2025

Google Photos for Android - Unlimited Photo and Video Storage with Latest Features in 2024, 2025

Discover the new features of Google Photos for Android in 2024 and 2025, including faster backup and advanced search capabilities.

Updated IQmango DVD Ripper 2024 - New Features and Enhancements

Updated IQmango DVD Ripper 2024 - New Features and Enhancements

Discover the latest version of IQmango DVD Ripper in 2024, a powerful software to easily rip, copy, convert, and back up DVDs.

When2meet - Tools to Arrange Group Meetings (Updated 2024, 2025)

When2meet - Tools to Arrange Group Meetings (Updated 2024, 2025)

When2meet is an easy-to-use group meeting scheduling tool for organizing collaborative meetings. Discover the latest features of When2meet for 2024 and 2025.