{"id":357012,"date":"2021-10-23T18:00:14","date_gmt":"2021-10-23T15:00:14","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-add-a-checkbox-in-google-sheets\/"},"modified":"2021-10-23T18:00:14","modified_gmt":"2021-10-23T15:00:14","slug":"how-to-add-a-checkbox-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-add-a-checkbox-in-google-sheets\/","title":{"rendered":"#How to Add a Checkbox in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6af6df42db120\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6af6df42db120\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-a-checkbox-in-google-sheets\/#How_to_Insert_a_Checkbox_in_Google_Sheets\" >How to Insert a Checkbox in Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-a-checkbox-in-google-sheets\/#Add_Custom_Values_to_a_Checkbox\" >Add Custom Values to a Checkbox<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-a-checkbox-in-google-sheets\/#Remove_Custom_Values_From_a_Checkbox\" >Remove Custom Values From a Checkbox<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Add a Checkbox in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731741\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Checkboxes are handy for all types of situations, even for data you add to a spreadsheet. In Google Sheets, you can add checkboxes for things like project tasks, answers to questions, or selecting product attributes.<\/p>\n<p>The nice thing about using a checkbox in Google Sheets is that you can also use data validation to assign custom values. So if you want to use conditional formatting, for example, you can use the checked or unchecked value to set up your rule.<\/p>\n<p>Here, we\u2019ll show you how to insert a checkbox in Google Sheets and assign custom values as well.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Insert_a_Checkbox_in_Google_Sheets\"><\/span>How to Insert a Checkbox in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Visit <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/\">Google Sheets<\/a>, sign in, and open the sheet you want to use. Select the cell where you want the checkbox. Then click Insert &gt; Checkbox from the menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-755171\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/InsertCheckbox-GoogleSheetsCheckbox.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Insert, Checkbox\" width=\"205\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And there you go; your checkbox is in the cell you selected ready to be checked!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-755170\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/InsertedCheckbox-GoogleSheetsCheckbox.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Checkbox in Google Sheets\" width=\"330\" height=\"100\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you want to add more checkboxes in adjacent cells, you can use the fill handle and drag your checkboxes through the remaining cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-755172\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/FillHandle-GoogleSheetsCheckbox.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Drag the fill handle to copy the checkbox \" width=\"650\" height=\"104\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To remove a checkbox you no longer need, just select the cell and press Delete on your keyboard.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Add_Custom_Values_to_a_Checkbox\"><\/span>Add Custom Values to a Checkbox<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>As mentioned, you can assign values to your checkbox for when it\u2019s checked and unchecked. Right-click the cell containing the checkbox and select \u201cData Validation.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-755178\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/DataValidation-GoogleSheetsCheckbox.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Right-click, select Data Validation\" width=\"553\" height=\"407\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the window <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ears, choose \u201cCheckbox\u201d in the Criteria drop-down box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-755177\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/DataValidationCheckbox-GoogleSheetsCheckbox.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose Checkbox\" width=\"570\" height=\"320\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Next, check the box for \u201cUse Custom Cell Values.\u201d Then enter the values for Checked and Unchecked. Click \u201cSave.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-755176\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/DataValidationValues-GoogleSheetsCheckbox.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Add the custom values\" width=\"570\" height=\"421\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Now if you want to use the values for something else in your sheet, such as the conditional formatting mentioned earlier, you\u2019ll have values to work with for your checked and unchecked box.<\/p>\n<blockquote class=\"admonishment_tip\"><p><strong>Tip:<\/strong> If you want to add checkboxes to adjacent cells using the same custom values, add the values to the first checkbox, then use the fill handle to drag the checkbox through the remaining cells.<\/p><\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Remove_Custom_Values_From_a_Checkbox\"><\/span>Remove Custom Values From a Checkbox<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you decide later that you no longer want the custom values you assigned, removing them is simple. Right-click the cell containing the checkbox and select \u201cData Validation\u201d just like when you added the values.<\/p>\n<p>Uncheck the box for Use Custom Cell Values and click \u201cSave.\u201d This allows you to keep your checkbox, but simply remove the assigned values.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-755175\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/DataValidationRemoveValues-GoogleSheetsCheckbox.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Remove the custom values\" width=\"570\" height=\"320\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you use Excel in addition to Sheets, take a look at how to use checkboxes to create a checklist in Microsoft Excel.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/755164\/how-to-add-a-checkbox-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Add a Checkbox in Google Sheets&#8221; Checkboxes are handy for all types of situations, even for data you add to a spreadsheet. In Google Sheets, you can add checkboxes for things like project tasks, answers to questions, or selecting product attributes. The nice thing about using a checkbox in Google Sheets is that&#8230;<\/p>\n","protected":false},"author":1,"featured_media":357013,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-357012","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/357012","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=357012"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/357012\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/357013"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=357012"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=357012"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=357012"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}