{"id":335161,"date":"2021-09-05T18:00:21","date_gmt":"2021-09-05T15:00:21","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-use-and-customize-a-theme-in-google-sheets\/"},"modified":"2021-09-05T18:00:21","modified_gmt":"2021-09-05T15:00:21","slug":"how-to-use-and-customize-a-theme-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-use-and-customize-a-theme-in-google-sheets\/","title":{"rendered":"#How to Use and Customize a Theme 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-6a393cc4ea1f2\" 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-6a393cc4ea1f2\" 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-use-and-customize-a-theme-in-google-sheets\/#About_Themes_in_Google_Sheets\" >About Themes in Google Sheets<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-and-customize-a-theme-in-google-sheets\/#Theme_Notes\" >Theme Notes<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-and-customize-a-theme-in-google-sheets\/#Apply_a_Theme_in_Google_Sheets\" >Apply a Theme in Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-and-customize-a-theme-in-google-sheets\/#Customize_a_Theme_in_Google_Sheets\" >Customize a Theme in Google Sheets<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Use and Customize a <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\">Theme<\/a> 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>If you want to add consistency and an attractive appearance to your spreadsheet, consider using a theme. In Google Sheets, you can select a premade theme as well as customize one to fit your style.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"About_Themes_in_Google_Sheets\"><\/span>About Themes in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you\u2019re concerned about too much pizzazz in a business spreadsheet, not to worry. Themes in Google Sheets only apply to specific areas and items in your sheet.<\/p>\n<ul>\n<li>Font style and color of grid text, charts, and pivot tables<\/li>\n<li>Link color of grid text<\/li>\n<li>Background color in charts<\/li>\n<li><a href=\"https:\/\/buradabiliyorum.com\/en\/category\/watch-movies-tv-seriess\/\" data-internallinksmanager029f6b8e52c=\"8\" title=\"Watch Movies &amp; TV Series\" target=\"_blank\" rel=\"noopener\">Series<\/a> color in charts<\/li>\n<li>Background color in pivot tables<\/li>\n<\/ul>\n<p><strong>RELATED:<\/strong> <strong><em>What are Pivot Tables in Google Sheets, and How Do I Use Them<\/em><\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Theme_Notes\"><\/span>Theme Notes<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>In addition to the above, here are a few things to note before you decide to use a theme.<\/p>\n<ul>\n<li>When you customize a theme, the most recent version is saved.<\/li>\n<li>The colors included in the theme you select are available in the text and fill color palettes.<\/li>\n<li>If you adjust the sheet formatting after you apply a theme, that formatting will override the theme.<\/li>\n<\/ul>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Apply_a_Theme_in_Google_Sheets\"><\/span>Apply a Theme in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now if you\u2019re ready to use a built-in theme to spruce up your spreadsheet, sign in to\u00a0<a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/\">Google Sheets<\/a> and open the sheet.<\/p>\n<p>Click Format &gt; Theme from the menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-745382\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/FormatTheme-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Format in the top menu and select Theme\" width=\"268\" height=\"130\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the Themes sidebar opens you\u2019ll see a nice collection of options. You currently have more than 15 themes from Retro and Groovy to Energetic and Earthy. Click the theme you want to use and it\u2019ll apply to your sheet im<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/social-mediaa\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Social Media\" target=\"_blank\" rel=\"noopener\">media<\/a>tely.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-745381\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/ThemesSidebar-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Themes sidebar in Google Sheets\" width=\"650\" height=\"458\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Create Templates in Google Docs<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Customize_a_Theme_in_Google_Sheets\"><\/span>Customize a Theme in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You may come across a theme that you like but would prefer to tweak it a tad bit. In the Themes sidebar, click \u201cCustomize\u201d at the top.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-745385\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/ThemesSidebarCustomize-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Customize\" width=\"286\" height=\"126\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can start by selecting a different style in the Font drop-down box. Pick from one of six font styles like Arial, Georgia, and Verdana.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-745384\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/ThemesSidebarCustomizeFont-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a style in the Font drop-down list\" width=\"241\" height=\"236\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Next, you can choose the theme colors. For each option, select a color from the palette or click \u201cCustom\u201d to enter a Hex code or use the shade slider for the exact color you want.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-745383\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/ThemesSidebarCustomizeColorCustom-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose a color or add a custom color\" width=\"510\" height=\"347\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can choose colors for the Text, Chart Background, Accents, and Hyperlinks. This gives you a wonderful way to personalize the sheet for your business or organization.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-745389\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/ThemesSidebarCustomizeColors-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose the theme Colors\" width=\"241\" height=\"428\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>As you make changes, you can see them immediately in the theme preview at the top of the sidebar as well as on your current sheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-745388 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/CustomTheme-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"View the theme changes immediately\" width=\"650\" height=\"458\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you finish, click \u201cDone\u201d at the top of the sidebar. You\u2019ll also notice that the name of the theme changes to Custom and this option displays at the top of the list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-745387\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/CustomThemeCreated-GoogleSheets.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Done and the Custom theme is the list\" width=\"600\" height=\"334\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>So if you want to try a different theme and decide you want the custom theme back, you can simply select it. Any theme customizations you make only apply and are available in your current workbook.<\/p>\n<p>Additionally, if you\u2019re looking for a subtle way to format your Google Sheets, you can also apply shading to alternating rows or columns.<\/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\/745376\/how-to-use-and-customize-a-theme-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Use and Customize a Theme in Google Sheets&#8221; If you want to add consistency and an attractive appearance to your spreadsheet, consider using a theme. In Google Sheets, you can select a premade theme as well as customize one to fit your style. About Themes in Google Sheets If you\u2019re concerned about too&#8230;<\/p>\n","protected":false},"author":1,"featured_media":335162,"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-335161","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\/335161","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=335161"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/335161\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/335162"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=335161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=335161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=335161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}