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.

Leave a Comment

Side Hustles That Actually Pay in 2026: 7 Realistic Options and the Tradeoffs to Know

Side Hustles That Actually Pay in 2026: 7 Realistic Options and the Tradeoffs to Know

Compare realistic side hustles for 2026 by startup cost, fees, flexibility, and income control, with current tax and scam guidance from official sources.

Remote Work Ergonomics in 2026: Upgrade Your Home Office Without Overbuying

Remote Work Ergonomics in 2026: Upgrade Your Home Office Without Overbuying

Upgrade your home office ergonomics with current OSHA and NIOSH guidance on chair fit, monitor height, laptop setup, lighting, and movement.

Why Emotional Intelligence Matters in Leadership—and How to Build It

Why Emotional Intelligence Matters in Leadership—and How to Build It

Learn why emotional intelligence matters in leadership, where it helps most, how to strengthen it, and how to tell whether your approach is working.

How to Transition to a Tech Career Without a Degree: A Results-First Roadmap for 2026

How to Transition to a Tech Career Without a Degree: A Results-First Roadmap for 2026

A practical roadmap for moving into tech without a degree: choose an accessible role, build job-ready skills, prove them with projects, and use hiring feedback to improve.

Building a Personal Brand on LinkedIn in 2026: What Still Works, What Changed, and What to Ignore

Building a Personal Brand on LinkedIn in 2026: What Still Works, What Changed, and What to Ignore

Build a credible LinkedIn personal brand in 2026 with current profile, content, newsletter, analytics, verification, and visibility guidance from LinkedIn.

Quiet Quitting vs. Quiet Firing in 2026: What’s Really Changing at Work

Quiet Quitting vs. Quiet Firing in 2026: What’s Really Changing at Work

Quiet quitting and quiet firing are catchy labels, not diagnoses. Learn what is verified, what depends on context, and what employees and managers can do next.

The Rise of the Fractional Executive: When Part-Time C-Suite Leadership Makes Sense

The Rise of the Fractional Executive: When Part-Time C-Suite Leadership Makes Sense

Fractional executives offer senior leadership without a full-time hire. Learn when the model works, what to ask, and the risks to manage.

How to Negotiate a Raise During Q4 Performance Reviews: A Practical 2026 Decision Guide

How to Negotiate a Raise During Q4 Performance Reviews: A Practical 2026 Decision Guide

Prepare a stronger Q4 raise request with current wage data, timing options, compensation tradeoffs, and scripts for yes, partial, or no outcomes.

6 High-Income Skills You Can Start Learning Before 2026 Ends

6 High-Income Skills You Can Start Learning Before 2026 Ends

Choose a high-income skill you can realistically start before 2026 ends, with current pay data, learning priorities, and a practical self-check.

Mastering the Hybrid Work Schedule: A Practical Framework That Actually Holds Up

Mastering the Hybrid Work Schedule: A Practical Framework That Actually Holds Up

Build a hybrid work schedule around tasks, team overlap, and measurable outcomes. See sample patterns, warning signs, and when to adjust your plan.