{"id":254708,"date":"2017-12-04T15:13:09","date_gmt":"2017-12-04T14:13:09","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=7540"},"modified":"2017-12-04T15:13:09","modified_gmt":"2017-12-04T14:13:09","slug":"color-google-sheets-tabs","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-features\/color-google-sheets-tabs\/","title":{"rendered":"Como colorir as guias do Planilhas Google?"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ min_height=”141px” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Google Sheets<\/a>\u00a0<\/span>primarily helps us handle information. In fact, a lot of it. Besides providing us with tools that help us reorganize, manipulate, analyze and summarize metrics. Because this cloud-based application lets us store huge data, the concept of worksheets makes sense. Because we can segregate similar information under various names. With this feature, fishing out specific information becomes a lot easier. Not only that, but we can also color Google Sheets tabs, and we will explain how in this article.<\/p>\n

 <\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Why color Google Sheets tabs?<\/h3>\n

While naming the worksheet tabs is already so beneficial, why do we have to color them at all? That\u2019s because color is far more intuitive and stands out. Also, our eyes tend to identify color much before text. Picking something from a collection becomes a lot easier when we can do it using color codes. Text takes us a lot more time and effort . Which is one of the reasons, even the traffic signals are color coded.<\/p>\n

For the purposes of demonstration, let us consider the a sample financial accounting spreadsheet. By default, an active worksheet tab is white while the inactive ones are in gray color.<\/p>\n

Example<\/strong><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/color-Google-Sheets-tab-1-1.png” alt=”color Google Sheets tab 1″ title_text=”color Google Sheets tab 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content”][et_pb_column _builder_version=”4.27.2″ _module_preset=”default” type=”4_4″ theme_builder_area=”post_content”][et_pb_text admin_label=”Connections T – Automate beyond importrange – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” saved_tabs=”all” global_colors_info=”{}” global_module=”50462″ theme_builder_area=”post_content”]\"\"<\/p>\n

\"39\"<\/p>\n

Automate data transfers beyond Importrange<\/span><\/p>\n

Find out how<\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

And, more often than not, we will have much higher number of tabs in data intensive spreadsheets. In such case, picking the right worksheet wouldn\u2019t be that straightforward, if we do not differentiate using colors.<\/p>\n

Intuitively, we associate expenses with red color and revenues with green. So, let us try that with tabs as well. Coloring a worksheet tab is pretty straightforward. Right click on the tab, select\u00a0<\/span>Change color<\/strong>, and click on a red shade that suits our preference.<\/p>\n

Example<\/strong><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/color-Google-Sheets-tab-2.png” alt=”color Google Sheets tab 2″ title_text=”color Google Sheets tab 2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

We will repeat it for the\u00a0<\/span>Revenue<\/strong>\u00a0<\/span>worksheet, except we choose a shade of green. Once done, this is how the Google Sheets file will look like.<\/p>\n

Example<\/strong><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/color-Google-Sheets-tab-3.png” alt=”color Google Sheets tab 3″ title_text=”color Google Sheets tab 3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Even if we had many other worksheets in the file, these colored ones easily stand out for us to be able to select them faster.<\/p>\n

On another note, go through the following blog posts to learn how you can easily\u00a0<\/span>Filter by color in Google Sheets<\/a> and how to create an alternated colors list in Google Sheets<\/a><\/span>.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Google Sheets\u00a0primarily helps us handle information. In fact, a lot of it. Besides providing us with tools that help us reorganize, manipulate, analyze and summarize metrics. Because this cloud-based application lets us store huge data, the concept of worksheets makes sense. Because we can segregate similar information under various names. With this feature, fishing out […]<\/p>\n","protected":false},"author":40,"featured_media":7833,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Google Sheets primarily helps us handle information. In fact, a lot of it. Besides providing us with tools that helps us reorganize, manipulate, analyze and summarize metrics. Because this cloud based application lets us store huge data, the concept of worksheets makes sense. Because, we can segregate similar information under various names. With this feature, fishing out specific information becomes a lot easier. Not only that, we can also color Google Sheets tabs, and we will explain how in this article.\n

Why color Google Sheets tabs?<\/h3>\nWhile naming the worksheet tabs is already so beneficial, why do we have to color them at all? That's because color is far more intuitive and stands out. Also, our eyes tend to identify color much before text. Picking something from a collection becomes a lot easier when we can do it using color codes. Text takes us a lot more time and effort . Which is one of the reasons, even the traffic signals are color coded.\n\nFor the purposes of demonstration, let us consider the a sample financial accounting spreadsheet. By default, an active worksheet tab is white while the inactive ones are in gray color.\n\n[panel type=\"default\"] Example<\/strong> \"Color[\/panel]\n\nAnd, more often than not, we will have much higher number of tabs in data intensive spreadsheets. In such case, picking the right worksheet wouldn't be that straightforward, if we do not differentiate using colors.\n\nIntuitively, we associate expenses with red color and revenues with green. So, let us try that with tabs as well. Coloring a worksheet tab is pretty straightforward. Right click on the tab, select Change color<\/strong>, and click on a red shade that suits our preference.\n\n[panel type=\"default\"] Example<\/strong> \"Color[\/panel]\n\nWe will repeat it for the Revenue<\/strong> worksheet, except we choose a shade of green. Once done, this is how the Google Sheets file will look like.\n\n[panel type=\"default\"] Example<\/strong> \"Color[\/panel]\n\nEven if we had many other worksheets in the file, these colored ones easily stand out for us to be able to select them faster.","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-254708","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/254708","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=254708"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/254708\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/7833"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=254708"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=254708"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=254708"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}