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 » 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

Why is my obs recording choppy How to Fix it

Why is My OBS Recording Choppy? 7 Ways to Fix It

June 11, 2023
dark-mode-on-notepad

3 Ways to Enable Dark Mode on Notepad

May 29, 2023
Ryzen Master Driver Not Installed

Fix: Ryzen Master Driver Not Installed Properly

April 17, 2023
how to open docx file

How to Open DOCX File? 4 Simple Ways

April 13, 2023
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
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
motherboard form factors

Motherboard Types: ATX, Micro ATX, and Mini ITX Explained

September 28, 2023
how to download and use rufus

How to Download and Use Rufus

September 28, 2023
how to turn off hardware acceleration

How to Turn Off Hardware Acceleration

September 27, 2023
You may also like
printer-not-printing

How to Fix a Printer That’s Not Printing

September 26, 2023
Share Location With Friends and Family

Share Location With Friends and Family (iPhone and Android)

September 18, 2023
how-to-print-without-a-printer

How to Print Without a Printer

September 18, 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.