Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»Excel»How to Put Check Mark in Excel

How to Put Check Mark in Excel

Asmi DhakalBy Asmi DhakalJanuary 20, 2023
check mark in excel

Excel is probably one of the best productivity applications out there. While users predominantly use it for professional reasons, you can use the application for personal use such as creating a to-do list. 

If you’re creating a list in Excel, you could add a checkmark next to the completed items. This will not only make your spreadsheet visually more appealing but, will also help you keep track of your lists.

There are three types of checkmarks you could add in Excel. One of the methods is to add a checkmark as a symbol while the second one involves using the Developer tab to insert a checkbox and add a checkmark. Similarly, you could also enter checkmarks as an icon! 

Depending on your needs, you can use either one of these methods to add a checkmark on your sheet.

Table of Contents

  • Insert Checkbox
    • Step 1: Enable Developer Tab
    • Step 2: Insert Checkbox in the Grid
    • Step 3: Put Check Mark
  • Insert Check Mark as Symbol
  • Insert Check Mark as an Icon

Insert Checkbox

Checkboxes will be a great addition to your document if you’re creating a to-do list. Checkboxes in MS Office are interactive. Whenever you complete a task from your list, you can simply click on the inserted box for a checkmark to appear.

To insert a checkbox, you need to first enable the Developer tab.

Step 1: Enable Developer Tab

  1. Head to File > Options.
    Excel Options
  2. From the sidebar, select Customize Ribbon.
  3. Under Customize the ribbon, select Main tab.
  4. Select the box next to Developer.
    Enable Developer Tab
  5. Click OK.

Step 2: Insert Checkbox in the Grid

  1. Head to the Developer tab.
  2. Select Insert.
  3. Click on the checkbox under Form Controls.
    Insert checkbox from developer tab Excel
  4. On the grid, click anywhere you wish to insert the checkbox.
    Insert Checkbox Excel
  5. Change the name of your item. You can also make the changes later by right-clicking on the checkbox item.
    Insert Checkbox in Excel
  6. Repeat steps 3 and 4 for all of your checkbox elements.

Step 3: Put Check Mark

Put Check in Excel

To insert a check mark, simply click on the empty checkbox. You can remove the check mark by clicking on the box again.

Insert Check Mark as Symbol

An easy way to add a checkmark in your spreadsheet is by inserting it as a symbol. Unlike adding a checkbox, symbols are static and non-interactive.

  1. Open your workbook.
  2. Head to the Insert tab and select Symbol.
    Symbol MS Excel
  3. Next to Font, choose Wingdings.
  4. Enter either 252 or 254 next to character code.
    Insert Check Symbol Excel
  5. Click Insert.

(Note: Character code 252 is a checkmark while character code 254 is a checkmark in a squared box.)

Insert Check Mark as an Icon

If you intend to use a checkmark for purely decorative purposes, you could insert it as an icon. You can resize your icon from the anchor points and even format them.

  1. Open your worksheet.
  2. From the Illustration section, select Icons.
    Insert Icons in Excel
  3. In the search bar, enter Check.
  4. Choose an icon and select Insert.
    Insert icon Excel
  5. Resize the icon and format the icon as you desire from the Graphics Format tab.
how-to
Asmi Dhakal
  • Twitter
  • LinkedIn

Asmi Dhakal is a Tech Writer specializing in Microsoft Office-based programs at TechNewsToday. She aims to use her experience to help others learn their way around its programs. Asmi’s interest in Office products grew when she first entered the marketing industry. While she initially struggled to understand their application, she eventually understood her way around them. In her articles, she exhibits a strong understanding of related issues and attempts to push only relevant fixes. Over time, she has grown a particular fondness for MS Excel and spends her free time learning Visual Basic Analysis (VBA). She’s always on the lookout for productivity tools that can get the job done quicker in Excel. Her approach to related problems is very humane, helping new users not only fix the issue but learn more about its nature. Asmi also heavily indulges in personal writing. She is a disciplined journal writer and has maintained a regular journal for 8 years! When her schedule allows, she works to rehabilitate street animals. You can contact her at asmi@technewstoday.com

Related Posts

How to Disable NVIDIA Overlay

5 Ways to Disable NVIDIA Overlay

February 23, 2023
Notepad++-Plugins-Not-Installing

Notepad++ Plugins Not Installing? 5 Proven Ways to Fix It

February 20, 2023
MSI-Gaming-App-Not-Opening

MSI Gaming App Not Opening? 6 Ways to Fix it

February 17, 2023
MSI Afterburner Not Working

MSI Afterburner Not Working? Try These 7 Fixes

February 17, 2023
best excel shortcuts

Best 52 Excel Shortcuts Only Experts Know

January 19, 2023
How to Find and edit Hyperlinks on Excel

How to Find and Edit Hyperlinks on Excel

January 23, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
what-does-spooling-mean-on-printer

What Does Spooling Mean on Printer?

March 23, 2023
sata ports on motherboard

All the Types of SATA Ports on Motherboard

March 21, 2023
anti-aliasing-on-or-off

What is Anti Aliasing? Should You Turn It on or off

March 21, 2023
You may also like
caps key not working

6 Ways to Fix Caps Key Not Working

March 23, 2023
how to increase ram on laptop

How to Increase RAM on Laptop? (Step-by-Step Guide)

March 23, 2023
how to overclock ram

How to Overclock RAM? (Step-by-Step Guide)

March 22, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Our Team
  • Editorial Guidelines
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday, editor@technewstoday.com | Tech Central Pvt. Ltd.

Type above and press Enter to search. Press Esc to cancel.