{"id":33558,"date":"2023-12-20T03:59:53","date_gmt":"2023-12-20T02:59:53","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=33558"},"modified":"2024-03-22T16:11:34","modified_gmt":"2024-03-22T15:11:34","slug":"inserting-check-marks-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/inserting-check-marks-in-excel\/","title":{"rendered":"Inserting Check Marks in Excel &#8211; 7 Easy Ways!"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-40.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-33612\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-40-1024x576.png\" alt=\"Check Mark in Excel\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-40-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-40-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-40-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-40.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/a>When creating <a class=\"wpil_keyword_link\" title=\"spreadsheets\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">spreadsheets<\/a>, you might find yourself needing to insert check marks in Excel to indicate completion, approval, or other status markers. In this article, we&#8217;ll explore several methods for <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-check-marks\/\" target=\"_blank\" rel=\"noopener\">inserting check marks<\/a> into your Excel worksheets.<\/p>\n<p>Let&#8217;s look at each of these methods!<\/p>\n<h4>Download the Excel Workbook below to follow along the Inserting a Check Mark in Excel tutorial! \u2013<\/h4>\n<p><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/CheckmarkinExcel.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel\u00a0<\/strong><strong>workbook<\/strong>\u00a0<\/span><span class=\"postTitle px-3\">CheckmarkinExcel.xlsx<\/span><\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/inserting-check-marks-in-excel\/#Copy_and_Paste\" title=\"Copy and Paste\">Copy and Paste<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/inserting-check-marks-in-excel\/#Using_the_Symbol_Command\" title=\"Using the Symbol Command\">Using the Symbol Command<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/inserting-check-marks-in-excel\/#Check_Marks_with_the_CHAR_Function\" title=\"Check Marks with the CHAR Function\">Check Marks with the CHAR Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/inserting-check-marks-in-excel\/#Insert_a_Checkbox\" title=\"Insert a Checkbox\">Insert a Checkbox<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/inserting-check-marks-in-excel\/#Check_Mark_in_Excel_with_AutoCorrect\" title=\"Check Mark in Excel with AutoCorrect\">Check Mark in Excel with AutoCorrect<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/inserting-check-marks-in-excel\/#Conditional_Formatting\" title=\"Conditional Formatting\">Conditional Formatting<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/inserting-check-marks-in-excel\/#Inserting_Check_Mark_as_an_Image\" title=\"Inserting Check Mark as an Image\">Inserting Check Mark as an Image<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Copy_and_Paste\"><\/span><strong><span id=\"1\" style=\"color: #ff0000\">Copy and Paste<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>By far, the easiest way to insert a check mark in Excel is by simply <strong>Copying and Pasting<\/strong> this symbol: &#x2714;<\/p>\n<p>Highlight &#x2714; and <strong>right-click<\/strong> to <strong>copy<\/strong> or press <strong>CTRL + C<\/strong>.<\/p>\n<p><strong>Paste<\/strong> the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-checkmark-symbol-in-excel\/\" target=\"_blank\" rel=\"noopener\">checkmark in<\/a> any cell in Excel by pressing <strong>Ctrl + V<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/CheckMarksinExcel1.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33561\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/CheckMarksinExcel1.jpg\" alt=\"Check Marks in Excel\" width=\"374\" height=\"178\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/CheckMarksinExcel1.jpg 374w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/CheckMarksinExcel1-300x143.jpg 300w\" sizes=\"(max-width: 374px) 100vw, 374px\" title=\"\"><\/a><\/p>\n<p><em>Note: This method is ideal for copying and pasting check marks in a few places manually. However, it is not practical for dealing with hundreds or thousands of cells, where using a <a class=\"wpil_keyword_link\" title=\"formula\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">formula<\/a> (as explained later in this tutorial) is a better approach.<\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Using_the_Symbol_Command\"><\/span><strong><span id=\"2\" style=\"color: #ff0000\">Using the Symbol Command<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Let&#8217;s consider an example in the context of marathon race qualifiers. We will insert a checkmark in a cell to indicate whether an athlete has qualified for the race if their time is 180 minutes or below:<\/p>\n<p>Enter the <strong>capital \u201cP\u201d or \u201cShift + P\u201d<\/strong> on the cells where you want the check marks to be.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Marks-in-Excel-2.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33562\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Marks-in-Excel-2.jpg\" alt=\"Check Marks in Excel\" width=\"506\" height=\"448\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Marks-in-Excel-2.jpg 506w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Marks-in-Excel-2-300x266.jpg 300w\" sizes=\"(max-width: 506px) 100vw, 506px\" title=\"\"><\/a><\/p>\n<p><strong>Highlight the range<\/strong> where you want to have the check marks.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Marks-in-Excel.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33563\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Marks-in-Excel.jpg\" alt=\"Check Marks in Excel\" width=\"539\" height=\"445\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Marks-in-Excel.jpg 539w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Marks-in-Excel-300x248.jpg 300w\" sizes=\"(max-width: 539px) 100vw, 539px\" title=\"\"><\/a><\/p>\n<p>Go up to the <strong>Home<\/strong> ribbon and click the <strong>Fonts drop-down menu<\/strong>. Change the font from <strong>Calibri<\/strong> to <strong>Wingdings 2<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Marks-in-Excel-4.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33564\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Marks-in-Excel-4.jpg\" alt=\"Check Marks in Excel\" width=\"496\" height=\"609\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Marks-in-Excel-4.jpg 496w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Marks-in-Excel-4-244x300.jpg 244w\" sizes=\"(max-width: 496px) 100vw, 496px\" title=\"\"><\/a><\/p>\n<p>Additionally, if you wanted to mark down the failed qualifications with an \u201c<strong>X<\/strong>\u201d, you can enter the <strong>uppercase \u201cO\u201d<\/strong> in the cell.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33565\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel.jpg\" alt=\"Check Mark in Excel\" width=\"488\" height=\"414\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel.jpg 488w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-300x255.jpg 300w\" sizes=\"(max-width: 488px) 100vw, 488px\" title=\"\"><\/a><\/p>\n<p>As you can see, by changing the font from <strong>Calibri<\/strong> to <strong>Wingdings 2<\/strong>, the uppercase <strong>P<\/strong> has been changed to the <strong>check mark<\/strong>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Check_Marks_with_the_CHAR_Function\"><\/span><strong><span id=\"3\" style=\"color: #ff0000\">Check Marks with the CHAR Function<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The CHAR function allows us to automate the process across a significant number of cells in an Excel <a class=\"wpil_keyword_link\" title=\"spreadsheet\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">spreadsheet<\/a>.<\/p>\n<p>Assuming you want to insert a checkmark if the value in cell <strong>B2 is lesser than or equal to 180<\/strong>:<\/p>\n<p>In cell <strong>C2<\/strong> (or any other cell where you want the checkmark to appear), enter the following formula:<\/p>\n<p><strong>=IF(B2&lt;=180, CHAR(252), &#8220;&#8221;)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-6.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33566\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-6.jpg\" alt=\"Check Mark in Excel\" width=\"675\" height=\"444\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-6.jpg 675w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-6-300x197.jpg 300w\" sizes=\"(max-width: 675px) 100vw, 675px\" title=\"\"><\/a><\/p>\n<p>You may get a return with the symbol <strong>\u00fc<\/strong>. That is perfectly fine. Apply the formula to the rest of the column by <strong>double-clicking the square<\/strong> on the <strong>bottom right-hand corner<\/strong> of cell <strong>C2<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-7.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33567\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-7.jpg\" alt=\"Check Mark in Excel\" width=\"513\" height=\"451\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-7.jpg 513w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-7-300x264.jpg 300w\" sizes=\"(max-width: 513px) 100vw, 513px\" title=\"\"><\/a><\/p>\n<p>Highlight cell <strong>C2 to C11<\/strong>. Go up to the <strong>Home<\/strong> ribbon and change the font to <strong>Wingdings<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-8.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33568\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-8.jpg\" alt=\"Check Mark in Excel\" width=\"499\" height=\"586\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-8.jpg 499w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-8-255x300.jpg 255w\" sizes=\"(max-width: 499px) 100vw, 499px\" title=\"\"><\/a><\/p>\n<p>As you can see, the cell in column C will dynamically display a checkmark if the value in cell <strong>B2 is lesser than or equal to 180<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-9.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33569\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-9.jpg\" alt=\"Check Mark in Excel\" width=\"505\" height=\"451\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-9.jpg 505w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-9-300x268.jpg 300w\" sizes=\"(max-width: 505px) 100vw, 505px\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Insert_a_Checkbox\"><\/span><strong><span id=\"4\" style=\"color: #ff0000\">Insert a Checkbox<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you do not have the <strong>Developer tab<\/strong> on the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-add-a-macro-to-the-quick-access-toolbar-ribbon-in-excel\/\" target=\"_blank\" rel=\"noopener\">Excel Ribbon<\/a>, start by going to the <strong>File<\/strong> menu. Choose <strong>Options<\/strong> and click on <strong>Customize<\/strong> the Ribbon.<\/p>\n<p>On the right side, make sure to check the box that says <strong>Developer<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-10.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33570\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-10.jpg\" alt=\"Check Mark in Excel\" width=\"819\" height=\"673\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-10.jpg 819w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-10-300x247.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-10-768x631.jpg 768w\" sizes=\"(max-width: 819px) 100vw, 819px\" title=\"\"><\/a><\/p>\n<p>Click on the <strong>Developer<\/strong> tab, go to <strong>Insert<\/strong>, and select the <strong>checkbox<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-12.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33571\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-12.jpg\" alt=\"Check Mark in Excel\" width=\"719\" height=\"580\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-12.jpg 719w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-12-300x242.jpg 300w\" sizes=\"(max-width: 719px) 100vw, 719px\" title=\"\"><\/a><\/p>\n<p><strong>Click and drag<\/strong> where you want the check box to appear on the cell. You can edit the text or completely remove it by right-clicking and selecting <strong>Edit Text<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-11.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33572\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-11.jpg\" alt=\"Check Mark in Excel\" width=\"519\" height=\"444\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-11.jpg 519w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-11-300x257.jpg 300w\" sizes=\"(max-width: 519px) 100vw, 519px\" title=\"\"><\/a> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-11-1.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-33573\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-11-1.jpg\" alt=\"\" width=\"519\" height=\"444\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-11-1.jpg 519w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-11-1-300x257.jpg 300w\" sizes=\"(max-width: 519px) 100vw, 519px\" title=\"\"><\/a><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-13.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33574\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-13.jpg\" alt=\"Check Mark in Excel\" width=\"607\" height=\"414\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-13.jpg 607w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-13-300x205.jpg 300w\" sizes=\"(max-width: 607px) 100vw, 607px\" title=\"\"><\/a><\/p>\n<p>Locate the small<strong> square on the bottom right-hand corner<\/strong> of the cell and drag down to apply the check box to the rest of the cells.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-14.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33575\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-14.jpg\" alt=\"Check Mark in Excel\" width=\"533\" height=\"416\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-14.jpg 533w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-14-300x234.jpg 300w\" sizes=\"(max-width: 533px) 100vw, 533px\" title=\"\"><\/a><\/p>\n<p>Now you can freely check or uncheck the box depending on whether the athletes qualification time.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-15.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33576\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-15.jpg\" alt=\"Check Mark in Excel\" width=\"533\" height=\"411\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-15.jpg 533w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-15-300x231.jpg 300w\" sizes=\"(max-width: 533px) 100vw, 533px\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-16.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33577\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-16.jpg\" alt=\"Check Mark in Excel\" width=\"500\" height=\"413\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-16.jpg 500w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-16-300x248.jpg 300w\" sizes=\"(max-width: 500px) 100vw, 500px\" title=\"\"><\/a><\/p>\n<p>There are many other methods for inserting <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-insert-checkbox-in-excel\/\" target=\"_blank\" rel=\"noopener\">checkboxes<\/a> in Excel!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Check_Mark_in_Excel_with_AutoCorrect\"><\/span><strong><span id=\"5\" style=\"color: #ff0000\">Check Mark in Excel with AutoCorrect<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/?p=20270&amp;preview=true\" target=\"_blank\" rel=\"noopener\">AutoCorrect<\/a> has many handy uses in Excel. But did you know you could replace a text with a check mark? Go to the <strong>File<\/strong> tab, select <strong>Options<\/strong>, and choose <strong>Proofing<\/strong>.<\/p>\n<p>Click on <strong>AutoCorrect Options<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-17.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33578\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-17.jpg\" alt=\"Check Mark in Excel\" width=\"820\" height=\"673\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-17.jpg 820w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-17-300x246.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-17-768x630.jpg 768w\" sizes=\"(max-width: 820px) 100vw, 820px\" title=\"\"><\/a><\/p>\n<p>In the <strong>Replace box<\/strong>, type the <a class=\"wpil_keyword_link\" title=\"shortcut\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">shortcut<\/a> \u201cchk&#8221; and in the \u201cWith&#8221; box, enter the check mark symbol.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-18.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33579\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-18.jpg\" alt=\"Check Mark in Excel\" width=\"404\" height=\"401\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-18.jpg 404w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-18-300x298.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-18-150x150.jpg 150w\" sizes=\"(max-width: 404px) 100vw, 404px\" title=\"\"><\/a><\/p>\n<p>Click <strong>Add<\/strong> and then <strong>OK<\/strong>.<\/p>\n<p>Enter <strong>chk<\/strong> in cell <strong>C2<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-19.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33580\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-19.jpg\" alt=\"Check Mark in Excel\" width=\"499\" height=\"411\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-19.jpg 499w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-19-300x247.jpg 300w\" sizes=\"(max-width: 499px) 100vw, 499px\" title=\"\"><\/a><\/p>\n<p>As you can see, Excel will AutoCorrect chk with the &#x2714;&#xfe0f; mark.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-20.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33581\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-20.jpg\" alt=\"Check Mark in Excel\" width=\"502\" height=\"414\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-20.jpg 502w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-20-300x247.jpg 300w\" sizes=\"(max-width: 502px) 100vw, 502px\" title=\"\"><\/a><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-22.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33582\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-22.jpg\" alt=\"Check Mark in Excel\" width=\"497\" height=\"409\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-22.jpg 497w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-22-300x247.jpg 300w\" sizes=\"(max-width: 497px) 100vw, 497px\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conditional_Formatting\"><\/span><strong><span id=\"6\" style=\"color: #ff0000\">Conditional Formatting<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Let&#8217;s say you want to insert a checkmark in <strong>column B<\/strong> when the value in the corresponding cell in column B is <strong>lesser than or equal to 180<\/strong>. This can be achieved with the power of <a href=\"https:\/\/support.microsoft.com\/en-au\/office\/highlight-patterns-and-trends-with-conditional-formatting-eea152f5-2a7d-4c1a-a2da-c5f893adb621\" target=\"_blank\" rel=\"noopener nofollow\">Microsoft\u2019s Conditional Formatting<\/a>.<\/p>\n<p><strong>Highlight the entire column<\/strong> or the range where you want the conditional formatting to be applied.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-23.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33583\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-23.jpg\" alt=\"Check Mark in Excel\" width=\"415\" height=\"445\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-23.jpg 415w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-23-280x300.jpg 280w\" sizes=\"(max-width: 415px) 100vw, 415px\" title=\"\"><\/a><\/p>\n<p>Go to the <strong>Home<\/strong> tab on the Excel ribbon.<\/p>\n<p>Click on <strong>Conditional Formatting<\/strong> in the toolbar.<\/p>\n<p>From the dropdown menu, select <strong>New Rule<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-24.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33584\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-24.jpg\" alt=\"Check Mark in Excel\" width=\"907\" height=\"580\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-24.jpg 907w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-24-300x192.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-24-768x491.jpg 768w\" sizes=\"(max-width: 907px) 100vw, 907px\" title=\"\"><\/a><\/p>\n<p>In the <strong>Select a Rule Type<\/strong> window, choose <strong>Format all cells based on their values<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-25.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33585\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-25.jpg\" alt=\"Check Mark in Excel\" width=\"597\" height=\"443\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-25.jpg 597w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-25-300x223.jpg 300w\" sizes=\"(max-width: 597px) 100vw, 597px\" title=\"\"><\/a><\/p>\n<p>On the <strong>Format Style<\/strong> dropdown arrow, choose <strong>Icon Sets<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-27.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33586\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-27.jpg\" alt=\"Check Mark in Excel\" width=\"598\" height=\"446\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-27.jpg 598w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-27-300x224.jpg 300w\" sizes=\"(max-width: 598px) 100vw, 598px\" title=\"\"><\/a><\/p>\n<p>For the <strong>Icon Style<\/strong>, choose the <strong>check marks and x marks<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-29.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33587\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-29.jpg\" alt=\"Check Mark in Excel\" width=\"595\" height=\"442\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-29.jpg 595w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-29-300x223.jpg 300w\" sizes=\"(max-width: 595px) 100vw, 595px\" title=\"\"><\/a><\/p>\n<p>Click on <strong>Reverse Icon Order<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-30.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33588\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-30.jpg\" alt=\"Check Mark in Excel\" width=\"360\" height=\"133\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-30.jpg 360w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-30-300x111.jpg 300w\" sizes=\"(max-width: 360px) 100vw, 360px\" title=\"\"><\/a><\/p>\n<p>Since we are looking for athletes who have a qualifying time of <strong>180 minutes or less<\/strong>, we will input an <strong>X when value is &gt;=181<\/strong>, <strong>! when &lt;186 and &gt;= 181<\/strong> (meaning it is close but not quite), and &#x2714; <strong>when the value is &lt;=180<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-31.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33589\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-31.jpg\" alt=\"Check Mark in Excel\" width=\"593\" height=\"270\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-31.jpg 593w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-31-300x137.jpg 300w\" sizes=\"(max-width: 593px) 100vw, 593px\" title=\"\"><\/a><\/p>\n<p>For the <strong>Type<\/strong>, choose <strong>Number<\/strong>.<\/p>\n<p>Click <strong>OK<\/strong>.<\/p>\n<p>Now, the checkmarks will be dynamically inserted in <strong>column B<\/strong>. If the value in cell in column B is lesser than or equal to 180, a checkmark will appear.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-32.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33600\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-32.jpg\" alt=\"Check Mark in Excel\" width=\"361\" height=\"421\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-32.jpg 361w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-32-257x300.jpg 257w\" sizes=\"(max-width: 361px) 100vw, 361px\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Inserting_Check_Mark_as_an_Image\"><\/span><strong><span id=\"7\" style=\"color: #ff0000\">Inserting Check Mark as an Image<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Download a check mark image<\/strong> or create one.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-33.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33601\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-33.jpg\" alt=\"Check Mark in Excel\" width=\"586\" height=\"634\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-33.jpg 586w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-33-277x300.jpg 277w\" sizes=\"(max-width: 586px) 100vw, 586px\" title=\"\"><\/a><\/p>\n<p>Go to the <strong>Insert<\/strong> tab and select <strong>Illustrations<\/strong>, then <strong>Pictures<\/strong> to insert the image into the desired cell.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-34.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33605\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-34.jpg\" alt=\"Check Mark in Excel\" width=\"557\" height=\"358\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-34.jpg 557w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-34-300x193.jpg 300w\" sizes=\"(max-width: 557px) 100vw, 557px\" title=\"\"><\/a><\/p>\n<p>Resize and position the image as needed.<\/p>\n<p>Press <strong>CTRL + C<\/strong> to copy, and <strong>CTRL + V<\/strong> to paste the image into other cells.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-35.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33608\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-35.jpg\" alt=\"Check Mark in Excel\" width=\"395\" height=\"280\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-35.jpg 395w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-35-300x213.jpg 300w\" sizes=\"(max-width: 395px) 100vw, 395px\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-36.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-33609\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-36.jpg\" alt=\"Check Mark in Excel 36\" width=\"349\" height=\"328\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-36.jpg 349w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Check-Mark-in-Excel-36-300x282.jpg 300w\" sizes=\"(max-width: 349px) 100vw, 349px\" title=\"\"><\/a><\/p>\n<p><strong>Conclusion<\/strong>:<br \/>\nThere you have it! Incorporating check marks into your Excel sheets enhances visual communication and helps in conveying information effectively. Choose the method that best suits your workflow!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When creating spreadsheets, you might find yourself needing to insert check marks in Excel to indicate completion, approval, or other status markers. In this article, we&#8217;ll explore several methods for inserting check marks into your Excel worksheets. Let&#8217;s look at each of these methods! Download the Excel Workbook below to follow along the Inserting a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":33612,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Inserting Check Marks in Excel - 7 Easy Ways!","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[35,3,10],"tags":[1510,1508,1506,1509,1507],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33558"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=33558"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33558\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/33612"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=33558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=33558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=33558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}