{"id":9671,"date":"2018-08-23T19:00:29","date_gmt":"2018-08-23T17:00:29","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=9671"},"modified":"2018-08-23T19:00:29","modified_gmt":"2018-08-23T17:00:29","slug":"formatar-celulas-no-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/spreadsheets-tips\/format-cells-in-google-sheets\/","title":{"rendered":"Como formatar c\u00e9lulas no Planilhas Google?"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ custom_padding=”||0px|||” 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″ custom_padding=”||0px|||” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

A cell is the tiniest entity and the most vital building block of a spreadsheet application. All the data that the spreadsheet holds is stored in these cells. While data storage is the fundamental utility of a cell, we have built-in tools to present this data well. In this blog post, we will discuss the ways we can\u00a0format cells<\/a> in Google Sheets.<\/p>\n

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

Format cells in Google Sheets<\/h3>\n

Formatting is the process of making the looks and feels of the spreadsheet better. More often with just a few adjustments, we can make the data easier to read and aesthetically appealing. Highlighted in the image below are the set of commands there are to\u00a0format cells in Google Sheets.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/2-format-cells-in-google-sheets-1.png” alt=”format cells in google sheets 1″ title_text=”2- format cells in google sheets 1″ _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 can broadly categorize them under number, text and cell formatting commands. To format cells, we just select them and choose an available formatting option(s) depending on our need. Please have a look at the following screenshot. Except for\u00a0<\/span>More formats<\/strong>\u00a0and\u00a0<\/span>Merge cells<\/strong>\u00a0formatting options, we tried to demonstrate all the others.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/2-format-cells-in-google-sheets-2.png” alt=”format cells in google sheets 2″ title_text=”format cells in google sheets 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

Please note that we can apply multiple formats on cells, that go together. For instance, the contents can be both bold and italic at the same time. However, there are certain combinations that won\u2019t work. For example, we cannot apply number formatting on a text-based cell. Similarly, a number can\u2019t be both a currency and a date, if that makes sense.<\/p>\n

More formats<\/strong>\u00a0[numbers]<\/h4>\n

We have myriad representations of a numeric value in Google Sheets. We can present it as a currency, time, date, long date, date-time, text, accounting figures etc. The\u00a0<\/span>More formats<\/strong>\u00a0<\/span>formatting menu option\u00a0consists of all these number formatting options as shown in the snapshot below.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/2-format-cells-in-google-sheets-3.png” alt=”format cells in google sheets 3″ title_text=”format cells in google sheets 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

Apart from the pre-defined number formats, we can also go for custom options, using which we can\u00a0<\/span>define our own formats<\/a>\u00a0<\/span>to suit our purposes.<\/p>\n

A simple example<\/h3>\n

Now we know what tools Google Sheets offer to make our presentation of cell contents. Let us apply this knowledge to format cells. As an example, please consider the cells\u00a0<\/span>A2:D9\u00a0and F2:I9<\/strong>\u00a0in the image below. Both these data sets represent\u00a0scores of a few students, albeit for different subjects. We left the math scores table as-is, while we did format cells from the science scores table. That way we clearly see the difference a few formatting steps create.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/2-format-cells-in-google-sheets-4.png” alt=”format cells in google sheets 4″ title_text=”format cells in google sheets 4″ _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

You will notice that the text \u201cStudent scores \u2013 Science\u201d spans across four cells \u2013\u00a0<\/span>F2:I2<\/strong>. But its Math counterpart is residing in just one cell \u2013\u00a0<\/span>B2<\/strong>. You may have guessed it already. We used the\u00a0<\/span>Merge cells<\/strong>\u00a0<\/span>formatting option on the cell range\u00a0F2:I2<\/strong>.<\/p>\n

Alter cell sizes<\/h3>\n

Apart from what we discussed so far, we may have to increase or decrease the sizes of the rows and\/or columns, to make the content fit the cells. To do this, place the cursor at the intersection of the column and\/or row labels. The cursor changes to a 2-way arrow, and we see that the intersection appears to be thicker and blue in color. Now click and drag the row\/column to adjust the sizes. Instead of dragging, we can also just double-click to let Google Sheets auto re-size the height\/width to fit the cell contents.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/2-format-cells-in-google-sheets-5.png” alt=”format cells in google sheets 5″ title_text=”format cells in google sheets 5″ _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″ custom_padding=”||1px|||” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Alternatively, select the entire row\/column by clicking on the row\/column header. Then right-click and choose\u00a0<\/span>resize row\/resize column<\/strong>\u00a0<\/span>option to input the number of pixels for height\/width.<\/p>\n

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

Moving cells around<\/h3>\n

We often need to shift the contents of the cells around. Google Sheets lets us handle that in more than one way. Just select the cell(s) that needs moving. We see the cursor turning into a hand, indicating that the cursor is now capable of holding them. Now drag the cell(s) to whichever place is suitable within the worksheet.<\/p>\n

Alternatively, right-click after selecting the cell(s), then choose either of the\u00a0<\/span>Insert [row(s)\/<\/strong>column(s)\/cells]<\/strong>\u00a0option. However, it is worth noting that the quickest and the age-old method is the cut-paste option using the keyboard shortcut\u00a0<\/span>Ctrl + X<\/strong>and\u00a0<\/span>Ctrl + V<\/strong>.<\/p>\n

Protect cells<\/h3>\n

Another useful feature that Google Sheets has, is that of protecting cells or even entire pages. If you haven\u2019t heard about this possibility yet, read more about it in\u00a0<\/span>this blog post<\/a>.<\/p>\n

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

A cell is the tiniest entity and the most vital building block of a spreadsheet application. All the data that the spreadsheet holds is stored in these cells. While data storage is the fundamental utility of a cell, we have built-in tools to present this data well. In this blog post, we will discuss the […]<\/p>\n","protected":false},"author":2,"featured_media":9672,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"A cell is the tiniest entity and the most vital building block of a spreadsheet application. All the data that the spreadsheet holds is stored in these cells. While data storage is the fundamental utility of a cell, we have built-in tools to present this data well. In this blog post, we will discuss the ways we can format cells in Google Sheets.\n

What exactly is formatting?<\/h3>\nIt is the process of making the looks and feels of the spreadsheet better. More often with just a few adjustments, we can make the data easier to read and aesthetically appealing. Highlighted in the image below are the set of formatting commands that Google Sheets offers.\n\n\"Format\n\nWe can broadly categorize them under number, text and cell formatting commands. To format cells, we just select them and choose an available formatting option(s) depending on our need. Please have a look at the following screenshot. Except for More formats<\/strong> and Merge cells<\/strong> formatting options, we tried to demonstrate all the others.\n\n\"Format\n\nPlease note that we can apply multiple formats on cells, that go together. For instance, the contents can be both bold and italic at the same time. However, there are certain combinations that won't work. For example, we cannot apply number formatting on a text-based cell. Similarly, a number can't be both a currency and a date, if that makes sense.\n

More formats<\/strong> [numbers]<\/h4>\nWe have myriad representations of a numeric value in Google Sheets. We can present it as a currency, time, date, long date, date-time, text, accounting figures etc. The More formats<\/strong> formatting menu option consists of all these number formatting options as shown in the snapshot below.\n\n\"Format\n\nApart from the pre-defined number formats, we can also go for custom options, using which we can define our own formats<\/a> to suit our purposes.\n

A simple example<\/h3>\nNow we know what tools Google Sheets offer to make our presentation of cell contents. Let us apply this knowledge to format cells. As an example, please consider the cells A2:D9 and F2:I9<\/strong> in the image below. Both these data sets represent scores of a few students, albeit for different subjects. We left the math scores table as-is, while we did format cells from the science scores table. That way we clearly see the difference a few formatting steps create.\n\n\"Format\n\nYou will notice that the text \"Student scores - Science\" spans across four cells - F2:I2<\/strong>. But its Math counterpart is residing in just one cell - B2<\/strong>. You may have guessed it already. We used the Merge cells<\/strong> formatting option on the cell range F2:I2<\/strong>.\n

Alter cell sizes<\/h3>\nApart from what we discussed so far, we may have to increase or decrease the sizes of the rows and\/or columns, to make the content fit the cells. To do this, place the cursor at the intersection of the column and\/or row labels. The cursor changes to a 2-way arrow, and we see that the intersection appears to be thicker and blue in color. Now click and drag the row\/column to adjust the sizes. Instead of dragging, we can also just double-click to let Google Sheets auto re-size the height\/width to fit the cell contents.\n\n\"Format\n\nAlternatively, select the entire row\/column by clicking on the row\/column header. Then right-click and choose resize row\/resize column<\/strong> option to input the number of pixels for height\/width.\n

Moving cells around<\/h3>\nWe often need to shift the contents of the cells around. Google Sheets lets us handle that in more than one way. Just select the cell(s) that needs moving. We see the cursor turning into a hand, indicating that the cursor is now capable of holding them. Now drag the cell(s) to whichever place is suitable within the worksheet.\n\nAlternatively, right-click after selecting the cell(s), then choose either of the Insert [row(s)\/<\/strong>column(s)\/cells]<\/strong> option. However, it is worth noting that the quickest and the age-old method is the cut-paste option using the keyboard shortcut Ctrl + X<\/strong> and Ctrl + V<\/strong>.","_et_gb_content_width":"","footnotes":""},"categories":[29],"tags":[28],"class_list":["post-9671","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheets-tips","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/9671","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=9671"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/9671\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/9672"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=9671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=9671"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=9671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}