{"id":7555,"date":"2017-11-03T17:15:54","date_gmt":"2017-11-03T16:15:54","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=6144"},"modified":"2017-11-03T17:15:54","modified_gmt":"2017-11-03T16:15:54","slug":"formatear-celdas-en-google-sheets-2","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/google-sheets-features\/format-cells-in-google-sheets-2\/","title":{"rendered":"C\u00f3mo dar formato a las celdas en Google Sheets"},"content":{"rendered":"\n[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″ global_colors_info=”{}” theme_builder_area=”post_content”]

Google Sheets not only allows us to store data, but it offers tools to make it look presentable. Probably many of us are aware of the fact that we can format the entire cell contents. But Google Sheets also lets us use multiple formats in a single cell. This article shows you the different possibilities of how you can\u00a0<\/span>format cells in Google Sheets.<\/em><\/strong><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

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

For the purposes of illustration, please consider the text in the cell B2 as shown in the screenshot below.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/format-cells-in-google-sheets-1.png” alt=”format cells in google sheets 1″ title_text=”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”]

Within the entire string of text, we will format the word \u2018bold\u2019 to \u2018bold<\/strong>\u2018, \u2018italics\u2019 to \u2018italics<\/em>\u2018, \u2018strikethrough\u2019 to \u2018strike through<\/del>\u2018. And similarly, convert the sub-text \u2018red\u2019 to \u2018red<\/span>\u2018, \u2018different font\u2019 to \u2018different font<\/span>\u2018, and \u2018different-sized font\u2019 to \u2018different-sized font<\/span>\u2018.<\/p>\n

In order to be able to do that, we need to double-click on the cell. Then we need to select individual sub-texts using either the keyboard or mouse. To start with, we will select the text \u2018bold\u2019. Now click on the\u00a0<\/span>Bold<\/strong>\u00a0<\/span>formatting option as highlighted in the image below.\u00a0Or alternatively, press the\u00a0<\/span>Ctrl + B<\/strong>\u00a0<\/span>(Cmd + B<\/strong>\u00a0<\/span>for Mac).<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/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”]

Similarly, select the \u2018italics\u2019 sub-text and click on the\u00a0<\/span>Italic<\/strong>\u00a0formatting option as highlighted in the snapshot below. Or alternatively, we can use the keyboard combination\u00a0<\/span>Ctrl + I<\/strong>\u00a0(<\/span>Cmd + I<\/strong>\u00a0for Mac).<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/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”]

Moving on, select the sub-string \u2018strike through\u2019, and click on the\u00a0<\/span>Strikethrough<\/strong>formatting option as highlighted in the image. An alternative approach is that we can use the key combination\u00a0<\/span>Alt + Shift + 5<\/strong>\u00a0(<\/span>Option + Shift + 5<\/strong>\u00a0in Mac).<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/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”]

To change the text color, we select the sub-text \u2018red\u2019. Then we click on the\u00a0<\/span>Text color<\/strong>\u00a0formatting option. It will show us a palette of color options which we can choose from. We were planning on the red color, so we will\u00a0<\/span>us<\/g>\u00a0select that.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/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″ global_colors_info=”{}” theme_builder_area=”post_content”]

Similarly, to change the font for the sub-text \u2018different font\u2019, we select it. Then click on the\u00a0<\/span>Font<\/strong>\u00a0drop-down. We will see the list of supported fonts, from which we choose\u00a0<\/span>Courier New<\/span>\u00a0font.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/format-cells-in-google-sheets-6.png” alt=”format cells in google sheets 6″ title_text=”format cells in google sheets 6″ _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”]

Finally, to change the font size of the sub-text \u2018different-sized font\u2019, we select it. Then click on the Font size drop-down, and choose the size 14.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/format-cells-in-google-sheets-7.png” alt=”format cells in google sheets 7″ title_text=”format cells in google sheets 7″ _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”]

Now that we are done with all formatting within the cell, we hit\u00a0<\/span>Enter<\/strong>\u00a0(<\/span>Return<\/strong>\u00a0in Mac). The cell B2 now looks as shown in the snapshot below.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/format-cells-in-google-sheets-8.png” alt=”format cells in google sheets 8″ title_text=”format cells in google sheets 8″ _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”]

Congratulations! We\u2019ve just learned how to\u00a0format cells in Google Sheets!<\/p>\n

If you want to expand this possibility even more, and\u00a0<\/span>export your Google Sheets data whilst maintaining the formatting, take a look at this blog post on How to Automatically Transfer Data and Formats From one Google Sheets File to Another.<\/a><\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"

Google Sheets not only allows us to store data, but it offers tools to make it look presentable. Probably many of us are aware of the fact that we can format the entire cell contents. But Google Sheets also lets us use multiple formats in a single cell. This article shows you the different possibilities […]<\/p>\n","protected":false},"author":40,"featured_media":7565,"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 not only allows us to store data, but it offers tools to make it look presentable. Probably many of us are aware of the fact that we can format the entire cell contents. But Google Sheets also lets us use multiple formats in a single cell. This article explains how we can make different text formats inside cells in Google Sheets.\n

The formatting procedure<\/h3>\nFor the purposes of illustration, please consider the text in the cell B2 as shown in the screenshot below.\n\n\"Different\n\nWithin the entire string of text, we will format the word 'bold' to 'bold<\/strong>', 'italics' to 'italics<\/em>', 'strikethrough' to 'strike through<\/del>'. And similarly, convert the sub-text 'red' to 'red<\/span>', 'different font' to 'different font<\/span>', and 'different-sized font' to 'different-sized font<\/span>'.\n\nIn order to be able to do that, we need to double-click on the cell. Then we need to select individual sub-texts using either the keyboard or mouse. To start with, we will select the text 'bold'. Now click on the Bold<\/strong> formatting option as highlighted in the image below.\u00a0Or alternatively, press the Ctrl + B<\/strong> (Cmd + B<\/strong> for Mac).\n\n\"Different\n\nSimilarly, select the 'italics' sub-text and click on the Italic<\/strong>\u00a0formatting option as highlighted in the snapshot below. Or alternatively, we can use the keyboard combination Ctrl + I<\/strong> (Cmd + I<\/strong> for Mac).\n\n\"Different\n\nMoving on, select the sub-string 'strike through', and click on the Strikethrough<\/strong> formatting option as highlighted in the image. An alternative approach is that we can use the key combination Alt + Shift + 5<\/strong>\u00a0(Option + Shift + 5<\/strong> in Mac).\n\n\"Different\n\nTo change the text color, we select the sub-text 'red'. Then we click on the Text color<\/strong> formatting option. It will show us a palette of color options which we can choose from. We were planning on the red color, so we will us select that.\n\n\"Different\n\nSimilarly, to change the font for the sub-text 'different font', we select it. Then click on the Font<\/strong> drop-down. We will see the list of supported fonts, from which we choose Courier New<\/span> font.\n\n\"Different\n\nFinally, to change the font size of the sub-text 'different-sized font', we select it. Then click on the Font size drop-down, and choose the size 14.\n\n\"Different\n\nNow that we are done with all formatting within the cell, we hit Enter<\/strong> (Return<\/strong> in Mac). The cell B2 now looks as shown in the snapshot below.\n\n\"Different\n\nCongratulations! We've just learned how to make different text formats inside cells in Google Sheets!\n\n
\n\nFeatured image designed by vilmosvarga \/ Freepik<\/a><\/em><\/span>","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-7555","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\/es\/wp-json\/wp\/v2\/posts\/7555","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=7555"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/7555\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/7565"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=7555"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=7555"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=7555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}