{"id":199177,"date":"2021-03-10T13:24:56","date_gmt":"2021-03-10T10:24:56","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-hide-gridlines-in-google-sheets\/"},"modified":"2021-03-10T13:24:56","modified_gmt":"2021-03-10T10:24:56","slug":"how-to-hide-gridlines-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-hide-gridlines-in-google-sheets\/","title":{"rendered":"#How to Hide Gridlines in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 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-6a414799344d7\" 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-6a414799344d7\" 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-hide-gridlines-in-google-sheets\/#Hide_Gridlines_in_Edit_View\" >Hide Gridlines in Edit View<\/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-hide-gridlines-in-google-sheets\/#Hide_Gridlines_in_Printed_Documents\" >Hide Gridlines in Printed Documents<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Hide Gridlines in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<!-- UNCACHED CONTENT --><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-395627\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2018\/11\/SheetsHeader.png\" alt=\"Google Sheets\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019re working in Google Sheets, you should already be familiar with its grid-like interface, where cells are separated by borderlines called gridlines. If you want to hide these gridlines from view, however, here\u2019s what you\u2019ll need to do.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Hide_Gridlines_in_Edit_View\"><\/span>Hide Gridlines in Edit View<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>By default, Google Sheets displays gridlines as you\u2019re editing a spreadsheet. These are the gray lines that separate each cell.\u00a0When you select a cell (or multiple cells), Sheets will surround it with a blue border.<\/p>\n<p>Gridlines are different from cell borders, which you can manually add to cells to make them stand out. Disabling gridlines in Google Sheets won\u2019t remove any additional cell borders or formatting you\u2019ve <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>lied to cells in your spreadsheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713072\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Example-Gridlines.png\" alt=\"Example cells in a Google Sheets spreadsheet with gridlines enabled.\" width=\"562\" height=\"254\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you want to hide the gridlines as you edit, however, you can.\u00a0Start by <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.google.com\/sheets\/about\/\">opening your Google Sheet spreadsheet<\/a> and clicking \u201cView\u201d from the menu bar.<\/p>\n<p>From the \u201cView\u201d menu, select the \u201cGridlines\u201d option to uncheck it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713074\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Disable-Gridlines-Option.png\" alt=\"To disable gridlines on Google Sheets, press View &gt; Gridlines in an open spreadsheet.\" width=\"474\" height=\"275\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once that\u2019s unchecked, all gridlines between cells across your spreadsheet will disappear from view. You should still see the blue border around the cells you select, however.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Hide_Gridlines_in_Printed_Documents\"><\/span>Hide Gridlines in Printed Documents<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The method above will hide gridlines as you edit a Google Sheets spreadsheet, but not if you decide to print it. When you print from Sheets, gridlines will cover the area containing any non-empty cells, allowing you to view them separately.<\/p>\n<p>If you want to hide gridlines from printed Google Sheets documents, however, you\u2019ll need to start by opening your spreadsheet and clicking File &gt; Print to open the printer settings menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-713075\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Print-Option.png\" alt=\"To begin printing a Google Sheets spreadsheet, press File &gt; Print.\" width=\"431\" height=\"600\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the \u201cPrint Settings\u201d menu, select the \u201cFormatting\u201d category option in the menu panel on the right. From the options listed below it, uncheck the \u201cShow Grid Lines\u201d option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713077\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Print-Disable-Gridlines.png\" alt=\"In the &quot;Print Settings&quot; menu, press Formatting &gt; Show Gridlines to remove visible gridlines from your document before printing.\" width=\"384\" height=\"475\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This will remove any visible gridlines from your spreadsheet during the printing process.<\/p>\n<p>Confirm the other print settings using the panel on the right, then check your spreadsheet layout using the print preview panel on the left. If you\u2019re happy to proceed, click \u201cNext\u201d to begin the printing process.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713078\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Print-Next-Option.png\" alt=\"To begin printing, press the &quot;Next&quot; option.\" width=\"351\" height=\"297\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Your browser or operating system\u2019s printer options menu should appear at this point.<\/p>\n<p>Make sure to confirm that the correct printer, page selection, and page sizes are selected, then select \u201cPrint\u201d in the bottom-right corner to begin printing your spreadsheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-713083\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/02\/Google-Sheets-Confirm-Print.png\" alt=\"In the printer dialog box, press the &quot;Print&quot; option to begin printing.\" width=\"356\" height=\"177\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Your Google Sheets spreadsheet should now print, showing the contents of your document, but with any visible gridlines removed.<\/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\/713062\/how-to-hide-gridlines-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Hide Gridlines in Google Sheets&#8221; If you\u2019re working in Google Sheets, you should already be familiar with its grid-like interface, where cells are separated by borderlines called gridlines. If you want to hide these gridlines from view, however, here\u2019s what you\u2019ll need to do. Hide Gridlines in Edit View By default, Google Sheets&#8230;<\/p>\n","protected":false},"author":1,"featured_media":199178,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2018\/11\/SheetsHeader.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-199177","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\/199177","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=199177"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/199177\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/199178"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=199177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=199177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=199177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}