{"id":28776,"date":"2023-04-20T21:05:14","date_gmt":"2023-04-20T19:05:14","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=28776"},"modified":"2024-02-06T18:44:56","modified_gmt":"2024-02-06T17:44:56","slug":"how-to-insert-checkbox-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-insert-checkbox-in-excel\/","title":{"rendered":"How to Insert Checkbox in Excel in 5 Easy Steps"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/50E119F4-CE95-4286-88B6-CEEF63ED5DA7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"aligncenter wp-image-29206 size-large\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/50E119F4-CE95-4286-88B6-CEEF63ED5DA7-1024x576.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/50E119F4-CE95-4286-88B6-CEEF63ED5DA7-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/50E119F4-CE95-4286-88B6-CEEF63ED5DA7-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/50E119F4-CE95-4286-88B6-CEEF63ED5DA7-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/50E119F4-CE95-4286-88B6-CEEF63ED5DA7.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Excel has many <strong>powerful tools<\/strong> that allow users to create<strong> dynamic, interactive, and user-friendly <\/strong>worksheets &#8211; A <strong>checkbox<\/strong>\u00a0is one such tool.<\/p>\n<h4>A Checkbox in Excel is a form control that can be used to<strong> select or deselect an option<\/strong> by simply clicking on it. When you<strong> select a checkbox, a small x mark appears<\/strong>\u00a0indicating that the option has been selected. If the<strong> box is empty<\/strong>, the<strong> option is not selected<\/strong>.<\/h4>\n<p>It can be used for creating <strong>checklists<\/strong>,<strong> form inputs, interactive charts<\/strong>,<strong> reports<\/strong>,<strong> dashboards,<\/strong> and much more.<\/p>\n<p>In this article, you will be covering the following Checkbox in Excel topics in detail &#8211;<\/p>\n<ul>\n<li><strong><a href=\"#1\">Activate Developer Tab<\/a><\/strong><\/li>\n<li><a href=\"#2\"><strong>Insert a Checkbox in Excel<\/strong><\/a><\/li>\n<li><a href=\"#3\"><strong>Insert Multiple Checkboxes in Excel<\/strong><\/a><\/li>\n<li><a href=\"#4\"><strong>Link Checkbox to a Cell<\/strong><\/a><\/li>\n<li><a href=\"#7\"><strong>Examples of Using Checkbox in Excel<\/strong><\/a><\/li>\n<li><a href=\"#6\"><strong>Delete Checkbox in Excel<\/strong><\/a><\/li>\n<\/ul>\n<p>Let&#8217;s look at each of these topics one by one!<\/p>\n<p>Make sure to download this Excel Workbook and follow along:<\/p>\n<p><a class=\"IRPP_minimalist icon-download hiddenmode replaced-link hiddenmode replaced-link button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Excel-Checkbox.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Excel-Checkbox.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">Excel-Checkbox.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"1\"><\/a>Activate a Developer Tab<\/strong><\/p>\n<p>The only way to create a checkbox is by using the Developer tab option. If it is not visible on your ribbon, <strong>follow the steps below<\/strong> to add it &#8211;<\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 1:<\/a><\/strong>\u00a0Right-click anywhere on your Ribbon and select\u00a0<strong>Customize the Ribbon.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-92.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28784\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-92.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"1063\" height=\"420\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-92.png 1063w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-92-300x119.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-92-1024x405.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-92-768x303.png 768w\" sizes=\"(max-width: 1063px) 100vw, 1063px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 2:<\/a><\/strong> Make sure the <strong>Customize Ribbon\u00a0<\/strong>is selected. Then select the\u00a0<strong>Developer\u00a0<\/strong>option under\u00a0<strong>Main Tabs<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-93.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28785\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-93.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"707\" height=\"578\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-93.png 1031w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-93-300x245.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-93-1024x837.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-93-768x628.png 768w\" sizes=\"(max-width: 707px) 100vw, 707px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 3: <\/a><\/strong>Click <strong>OK.<\/strong><\/p>\n<h2><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-94.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28786\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-94.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"685\" height=\"566\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-94.png 1033w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-94-300x248.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-94-1024x846.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-94-768x634.png 768w\" sizes=\"(max-width: 685px) 100vw, 685px\" \/><\/a><\/h2>\n<p>The <strong>Developer tab<\/strong> will now show up on the ribbon.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-95.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28787\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-95.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"1066\" height=\"273\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-95.png 1066w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-95-300x77.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-95-1024x262.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-95-768x197.png 768w\" sizes=\"(max-width: 1066px) 100vw, 1066px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"2\"><\/a>Insert a Checkbox in Excel<\/strong><\/p>\n<p>Once you have the Developer tab visible on your ribbon, you can follow the steps below to insert a Checkbox in Excel &#8211;<\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 1:<\/a><\/strong> Click on <strong>Developer<\/strong> Tab.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-95.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28787\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-95.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"1066\" height=\"273\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-95.png 1066w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-95-300x77.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-95-1024x262.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-95-768x197.png 768w\" sizes=\"(max-width: 1066px) 100vw, 1066px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 2:<\/a><\/strong> Under the <strong>Controls<\/strong>, Click on <strong>Insert.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-96.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28788\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-96.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"1082\" height=\"222\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-96.png 1082w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-96-300x62.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-96-1024x210.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-96-768x158.png 768w\" sizes=\"(max-width: 1082px) 100vw, 1082px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 3:<\/a><\/strong> Click on the<strong> Checkbox icon\u00a0<\/strong>under Form Controls (small box with a blue tick).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-97.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28789\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-97.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"1084\" height=\"464\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-97.png 1084w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-97-300x128.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-97-1024x438.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-97-768x329.png 768w\" sizes=\"(max-width: 1084px) 100vw, 1084px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 4:<\/a><\/strong> Click anywhere on the sheet, and the checkbox will be inserted there.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-101.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28797\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-101.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"441\" height=\"360\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-101.png 419w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-101-300x245.png 300w\" sizes=\"(max-width: 441px) 100vw, 441px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 5: <\/a><\/strong>Right-click and select <strong>Edit Text<\/strong>. <em>You can edit or remove text as needed.<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-102.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28798\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-102.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"442\" height=\"315\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-102.png 566w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-102-300x214.png 300w\" sizes=\"(max-width: 442px) 100vw, 442px\" \/><\/a><\/p>\n<p>The checkbox is now ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-103.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28799\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-103.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"427\" height=\"344\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-103.png 427w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-103-300x242.png 300w\" sizes=\"(max-width: 427px) 100vw, 427px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"3\"><\/a>Insert Multiple Checkboxes in Excel<\/strong><\/p>\n<p>Now that you have added a checkbox to cell B2 &#8211; How do you<strong> insert them for the remaining cells<\/strong>?<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-103.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28799\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-103.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"427\" height=\"344\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-103.png 427w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-103-300x242.png 300w\" sizes=\"(max-width: 427px) 100vw, 427px\" \/><\/a><\/p>\n<p>If you try to add the checkboxes one by one using the method shown above it will be a time-consuming process. There are <strong>2 ways in which you can quickly add multiple checkboxes<\/strong> to your Excel worksheet.<\/p>\n<p>Let&#8217;s look at them.<\/p>\n<p><strong><a style=\"color: #ff0000;\">Method 1 &#8211; Copy Paste<\/a><\/strong><\/p>\n<p>You can simply <strong>copy the checkbox added in cell B2 and paste them into the required range<\/strong>.<\/p>\n<ul>\n<li><strong>Select the cell<\/strong> containing the checkbox<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-104.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28801\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-104.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"602\" height=\"529\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-104.png 737w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-104-300x264.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/a><\/li>\n<li>Press <strong>Ctrl\u00a0 + C<\/strong> to copy it.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-105.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28802\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-105.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"603\" height=\"464\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-105.png 861w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-105-300x231.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-105-768x590.png 768w\" sizes=\"(max-width: 603px) 100vw, 603px\" \/><\/a><\/li>\n<li>Select the cells where you want to paste and then press <strong>Ctrl + V<\/strong>.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-106.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28803\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-106.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"606\" height=\"456\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-106.png 865w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-106-300x226.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-106-768x578.png 768w\" sizes=\"(max-width: 606px) 100vw, 606px\" \/><\/a><\/li>\n<\/ul>\n<p><em>You can also highlight all the cells and use the keyboard <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\" title=\"shortcut\" data-wpil-keyword-link=\"linked\">shortcut<\/a> <strong>Ctrl + D<\/strong> to achieve the same result!<\/em><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a style=\"color: #ff0000;\">Method 2 &#8211; Drag and Fill<\/a><\/strong><\/p>\n<p>In this method, you can <strong>select the cell<\/strong> containing the checkbox and then<strong> move your cursor to the bottom right corner<\/strong> of the cell. The<strong> arrow will convert into a thin black cross<\/strong>\u00a0<strong>icon<\/strong>.<\/p>\n<p>Now, simply <b>drag and fill the checkboxes<\/b>\u00a0to the cells below.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-108.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28804\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-108.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"652\" height=\"482\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-108.png 858w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-108-300x222.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-108-768x567.png 768w\" sizes=\"(max-width: 652px) 100vw, 652px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"4\"><\/a>\u00a0Link Checkbox to a Cell<\/strong><\/p>\n<p>You can<strong> link the value of the checkbox to a cell address<\/strong> in your worksheet. When you<strong> select the checkbox<\/strong>, the value in the linked cell will display <strong>TRUE<\/strong> <strong>otherwise it will display FALSE<\/strong>.<\/p>\n<p>You can use this value in the cell to perform various actions like <strong>conditional formatting, creating interactive charts or reports, hiding or unhiding rows\/columns<\/strong>, etc. Let&#8217;s see how you can link a checkbox to a cell:<\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 1: <\/a>Right-click<\/strong> on the checkbox and select <strong>Format Control<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-109.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28806\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-109.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"614\" height=\"672\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-109.png 614w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-109-274x300.png 274w\" sizes=\"(max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 2: <\/a><\/strong>In the Format Object window, go to <strong>Control<\/strong> Tab.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-110.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28807\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-110.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"442\" height=\"378\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-110.png 630w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-110-300x257.png 300w\" sizes=\"(max-width: 442px) 100vw, 442px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 3: <\/a><\/strong> Under the<strong> Cell link<\/strong>,<strong> select the cell<\/strong> where you want the value to be displayed. <em>Here, it is cell C2.<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-114-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28810\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-114-1.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"446\" height=\"377\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-114-1.png 633w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-114-1-300x254.png 300w\" sizes=\"(max-width: 446px) 100vw, 446px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 4: <\/a><\/strong>Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-114.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28811\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-114.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"446\" height=\"378\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-114.png 630w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-114-300x254.png 300w\" sizes=\"(max-width: 446px) 100vw, 446px\" \/><\/a><\/p>\n<p>You can see that since the <strong>checkbox is not selected<\/strong>, the value in cell C2 is showing <strong>FALSE<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-113.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28809\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-113.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"521\" height=\"367\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-113.png 521w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-113-300x211.png 300w\" sizes=\"(max-width: 521px) 100vw, 521px\" \/><\/a><\/p>\n<p>Once you <strong>select the checkbox<\/strong>, the value will change to <strong>TRUE<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-112.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28808\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-112.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"517\" height=\"367\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-112.png 517w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-112-300x213.png 300w\" sizes=\"(max-width: 517px) 100vw, 517px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"7\"><\/a>Example of Using Checkbox in Excel<\/strong><\/p>\n<p>In this example, you have a list of topics that needs to be covered by a student. You need to <strong>use the checkboxes in Excel to <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" title=\"track\" data-wpil-keyword-link=\"linked\">track<\/a> the progress<\/strong> and <strong>provide a summary<\/strong> for the same.<\/p>\n<p>You also have to <strong>strikethrough the topics that have been completed<\/strong> and <strong>add a green color fill<\/strong> to them. This can be achieved using the<strong> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/pivot-tables\/conditional-formatting\/\" target=\"_blank\" rel=\"nofollow noopener\">Conditional Formatting<\/a><\/strong> option in Excel.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-146.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28848\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-146.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"427\" height=\"306\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-146.png 563w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-146-300x215.png 300w\" sizes=\"(max-width: 427px) 100vw, 427px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 1: <\/a><\/strong>Go to <strong>Developer<\/strong> Tab &gt; <strong>Insert<\/strong> &gt; <strong>Checkbox<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-147.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28857\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-147.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"598\" height=\"317\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-147.png 771w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-147-300x159.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-147-768x407.png 768w\" sizes=\"(max-width: 598px) 100vw, 598px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 2: <\/a><\/strong> Click on cell B2 to insert the checkbox in that cell.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-148.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28858\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-148.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"444\" height=\"346\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-148.png 503w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-148-300x234.png 300w\" sizes=\"(max-width: 444px) 100vw, 444px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 3: <\/a><\/strong>Right-click and select <strong>Edit Text<\/strong>. Clear the text.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-149.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28859\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-149.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"445\" height=\"345\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-149.png 551w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-149-300x232.png 300w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 4: <\/a>Drag and fill<\/strong> the checkboxes in range B3:B11.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-150.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28860\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-150.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"451\" height=\"353\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-150.png 516w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-150-300x235.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 5: <\/a><\/strong>Right-click on the checkbox and select <strong>Format Control<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-151.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28861\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-151.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"470\" height=\"370\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-151.png 531w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-151-300x236.png 300w\" sizes=\"(max-width: 470px) 100vw, 470px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 6: <\/a>Select cell C2<\/strong> in the cell link option.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-114-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28810\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-114-1.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"411\" height=\"347\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-114-1.png 633w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-114-1-300x254.png 300w\" sizes=\"(max-width: 411px) 100vw, 411px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 7: <\/a><\/strong> Do this for all the checkboxes.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-152.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28862\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-152.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"434\" height=\"349\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-152.png 513w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-152-300x242.png 300w\" sizes=\"(max-width: 434px) 100vw, 434px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 8: <\/a><\/strong> In cell B13, insert the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/counta-formula-excel\/\" target=\"_blank\" rel=\"nofollow noopener\"><strong>COUNTA<\/strong><\/a> formula to get the total number of topics covered.<\/p>\n<p>=COUNTA(A2:A11)<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-153.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28863\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-153.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"402\" height=\"375\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-153.png 513w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-153-300x280.png 300w\" sizes=\"(max-width: 402px) 100vw, 402px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 9: <\/a><\/strong> In cell B14, insert the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/countif-formula-excel-2\/\" target=\"_blank\" rel=\"nofollow noopener\"><strong>COUNTIF<\/strong><\/a> function to get the total number of TRUE in range C2:C11. These cells will display TRUE only when the checkbox is selected indicating that the topic has been covered.<\/p>\n<p>=COUNTIF(C2:C11,&#8221;TRUE&#8221;)<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-154.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28864\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-154.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"409\" height=\"359\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-154.png 514w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-154-300x263.png 300w\" sizes=\"(max-width: 409px) 100vw, 409px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 10: <\/a><\/strong> In cell B15, to get the percentage of topics covered simply divide B14 by B13.<\/p>\n<p>=B14\/B13<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-155.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28865\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-155.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"409\" height=\"367\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-155.png 512w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-155-300x269.png 300w\" sizes=\"(max-width: 409px) 100vw, 409px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 11: <\/a><\/strong>To add conditional formatting, <strong>select the cell range<\/strong> where you want the formatting to be shown. Here, it is cell A2:A11.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-138.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28849\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-138.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"455\" height=\"357\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-138.png 520w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-138-300x235.png 300w\" sizes=\"(max-width: 455px) 100vw, 455px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 12:<\/a><\/strong> Go to <strong>Home<\/strong> &gt; <strong>Condition Formatting<\/strong> &gt; <strong>New Rule<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-139.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28850\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-139.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"1127\" height=\"484\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-139.png 1430w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-139-300x129.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-139-1024x440.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-139-768x330.png 768w\" sizes=\"(max-width: 1127px) 100vw, 1127px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 13:<\/a><\/strong> In the New Formatting Rule dialog box, select <strong>Use a formula to determine which cells to format<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-140.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28851\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-140.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"635\" height=\"452\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-140.png 635w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-140-300x214.png 300w\" sizes=\"(max-width: 635px) 100vw, 635px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 14:<\/a><\/strong> Type the formula stated below &#8211;<\/p>\n<p>=$C2=TRUE<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-141-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28852\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-141-1.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"640\" height=\"449\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-141-1.png 640w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-141-1-300x210.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 15: <\/a><\/strong>Click on the <strong>Format<\/strong> button.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-141.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28853\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-141.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"640\" height=\"449\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-141.png 640w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-141-300x210.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 16:<\/a><\/strong> Under the <strong>Fill<\/strong> tab, select the light green color.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-143.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28854\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-143.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"671\" height=\"665\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-143.png 671w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-143-300x297.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-143-150x150.png 150w\" sizes=\"(max-width: 671px) 100vw, 671px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 17: <\/a><\/strong>Under the <strong>Font<\/strong> tab, select <strong>Strikethrough<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-144.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28855\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-144.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"672\" height=\"667\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-144.png 672w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-144-300x298.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-144-150x150.png 150w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">STEP 18:<\/a><\/strong> Double-check the result under Preview and then click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-145.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28856\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-145.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"638\" height=\"453\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-145.png 638w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-145-300x213.png 300w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><\/a><\/p>\n<p>And Voila, you will see that the desired result has been achieved. The topics that have been marked as completed in the checkbox are strikethrough and highlighted in green as well.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-146.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28848\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-146.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"509\" height=\"364\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-146.png 563w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-146-300x215.png 300w\" sizes=\"(max-width: 509px) 100vw, 509px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a id=\"6\"><\/a>Delete Checkbox in Excel<\/strong><\/p>\n<p>Deleting a single checkbox is a straightforward task but deleting multiple checkboxes in your worksheet can become tedious. You can follow any of the following methods below to delete multiple checkboxes at once:<\/p>\n<p><strong><a style=\"color: #ff0000;\">Method 1: Use the Ctrl key<\/a><\/strong><\/p>\n<ul>\n<li><strong>Press and hold the Ctrl key<\/strong> on your keyboard and<strong> select all checkboxes<\/strong>.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-115.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28812\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-115.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"432\" height=\"353\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-115.png 432w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-115-300x245.png 300w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/><\/a><\/li>\n<li>Press the <strong>Delete<\/strong> button on your keyboard.<\/li>\n<\/ul>\n<p>All the selected checkboxes will be deleted.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-116.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28813\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-116.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"439\" height=\"380\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-116.png 439w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-116-300x260.png 300w\" sizes=\"(max-width: 439px) 100vw, 439px\" \/><\/a><\/p>\n<p><strong><a style=\"color: #ff0000;\">Method 2: Use the Selection Pane<\/a><\/strong><\/p>\n<ul>\n<li>Go to <strong>Home<\/strong> &gt; <strong>Find &amp; Select<\/strong>.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-117.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28817\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-117.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"1819\" height=\"160\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-117.png 1819w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-117-300x26.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-117-1024x90.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-117-768x68.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-117-1536x135.png 1536w\" sizes=\"(max-width: 1819px) 100vw, 1819px\" \/><\/a><\/li>\n<li>In the dropdown, click on <strong>Selection Pane<\/strong>.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-119.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28818\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-119.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"1899\" height=\"583\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-119.png 1899w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-119-300x92.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-119-1024x314.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-119-768x236.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-119-1536x472.png 1536w\" sizes=\"(max-width: 1899px) 100vw, 1899px\" \/><\/a><\/li>\n<li>In the Selection Pane, <strong>select the checkboxes<\/strong> you want to delete.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-120.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28819 \" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-120-e1681763330113.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"248\" height=\"407\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-120-e1681763330113.png 314w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-120-e1681763330113-183x300.png 183w\" sizes=\"(max-width: 248px) 100vw, 248px\" \/><\/a><\/li>\n<li>Press the <strong>Delete <\/strong>button on your keyboard.<\/li>\n<\/ul>\n<p>All the selected checkboxes will be deleted.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-116.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28813\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-116.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"439\" height=\"380\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-116.png 439w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-116-300x260.png 300w\" sizes=\"(max-width: 439px) 100vw, 439px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><a style=\"color: #ff0000;\">Method 3: Use the Go To Special option<\/a><\/strong><\/p>\n<ul>\n<li>Press<strong> Ctrl + G<\/strong> to open the Go To dialog box. Select <strong>Special<\/strong>.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-121.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28820\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-121.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"339\" height=\"282\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-121.png 416w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-121-300x250.png 300w\" sizes=\"(max-width: 339px) 100vw, 339px\" \/><\/a><\/li>\n<li>In the Go to Special dialog box, select <strong>Objects<\/strong>. Click <strong>OK<\/strong>.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-122.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28821\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-122.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"327\" height=\"374\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-122.png 375w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-122-262x300.png 262w\" sizes=\"(max-width: 327px) 100vw, 327px\" \/><\/a><\/li>\n<li>All the checkboxes will be selected.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-115.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone wp-image-28812\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-115.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"341\" height=\"279\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-115.png 432w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-115-300x245.png 300w\" sizes=\"(max-width: 341px) 100vw, 341px\" \/><\/a><\/li>\n<li>Press <strong>Delete<\/strong>.<\/li>\n<\/ul>\n<p>All the selected checkboxes will be deleted.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-116.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Insert Checkbox in Excel in 5 Easy Steps\"  class=\"alignnone size-full wp-image-28813\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-116.png\" alt=\"How to Insert Checkbox in Excel in 5 Easy Steps\" width=\"439\" height=\"380\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-116.png 439w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/04\/Screenshot-116-300x260.png 300w\" sizes=\"(max-width: 439px) 100vw, 439px\" \/><\/a><\/p>\n<p>The only limitation of this method is that <strong>all objects in the active worksheet including shapes, charts, dropdowns, etc. will be deleted<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Conclusion<\/strong><\/p>\n<p>A Checkbox is a very useful feature in Excel that allows users to select or deselect an option. It is helpful as it prevents users from manually entering data hence reducing the scope of error. It can be used for creating forms, checklists, interactive charts, reports, etc.<\/p>\n<p>In this article, we have covered how to insert single or multiple checkboxes in Excel, link the value to a cell, and delete them as well.<\/p>\n<p>For more tips and tricks to master Excel, check our Excel online classes below!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel has many powerful tools that allow users to create dynamic, interactive, and user-friendly worksheets &#8211; A checkbox\u00a0is one such tool. A Checkbox in Excel is a form control that can be used to select or deselect an option by simply clicking on it. When you select a checkbox, a small x mark appears\u00a0indicating that [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":29206,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[648],"tags":[1193,1192,1191],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/28776"}],"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=28776"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/28776\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/29206"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=28776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=28776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=28776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}