how do I make a check mark in excel

You can use an Icon set to show check marks (and other symbols) based on data, example:

Check out this link:

https://support.office.com/en-gb/article/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f

Andreas.

Here are some more options

Checkbox- Typing Check Marks into Excelhttps://excelribbon.tips.net/T011474_Typing_Check_Marks_into_Excel ****Need to enter a check mark into a cell? There are a number of ways you can get the desired character, depending on the font you want to use.

ET MR Macros.docx.

add check mark in a cell with double clicking in Excel? **** https://www.extendoffice.com/documents/excel/3923-excel-double-click-for-check-mark.html

Normally, for inserting a check mark in a cell, you need to get into the Symbol dialog box, find the check mark symbol and insert it manually. But it is not so easy to find out the check mark symbol in the Symbol dialog box as there are numerous symbols listed inside. How to quickly add a check mark in a cell in Excel? This article will show you a VBA method to easily add check mark in a cell with double clicking only.

.

insert check mark symbols in Excel?

https://www.extendoffice.com/documents/excel/3379-excel-insert-check-mark-symbols.html

For example you want to make a questionnaire in Excel, and you need to insert some check mark symbols into it. How to quickly find out the check mark symbols and insert? You can follow below methods:

.

Validate input with check mark****IF   COUNTIF

https://exceljet.net/formula/validate-input-with-check-mark

To display a check mark if the value passes some kind of test, you can use a formula based on the IF function together a symbolic font like Wingdings.

.

Simple way is

Please refer this link for interactive check lists in excel

https://www.ablebits.com/office-addins-blog/201...

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

To:  MichaelNeben

re:  checkmarks

Another way, by changing the font used...

£

'---

Excel programs (now free) at MediaFire...The Custom_Functions add-in has 20 new Excel functions including the vLookUpAny function

Download from... *http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents*

Hi, Michaelneben. I am Mitch, an independent advisor. I will try to help.
Please check this link.
https://support.office.com/en-us/article/insert...
Thank you.