{"id":422,"date":"2018-10-17T01:49:07","date_gmt":"2018-10-17T01:49:07","guid":{"rendered":"http:\/\/www.alandaletraining.com\/software-tips\/?p=422"},"modified":"2018-10-17T01:49:07","modified_gmt":"2018-10-17T01:49:07","slug":"format-only-some-of-the-text-in-an-excel-cell","status":"publish","type":"post","link":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/10\/17\/format-only-some-of-the-text-in-an-excel-cell\/","title":{"rendered":"Format only some of the text in an Excel cell"},"content":{"rendered":"

One of the first things most Excel users quickly discover is how to change the font, font size and colour of text in cell.<\/p>\n

However, you may not have discovered that you can format only some of the content in a cell.\u00a0 This may be handy, for instance, if you have descriptive notes in a cell and you want to highlight a few words to emphasize a point.<\/p>\n

To highlight only part of the text stored in a cell:
\n– Double-click on the cell or select it and then click in the Formula Bar
\n– Select the content you want to format
\n– Apply formatting as needed using the Ribbon or Mini Toolbar
\n– Press Enter or Tab<\/p>\n

Note that you are fairly limited in the Font formatting you can apply: Font, Font size, Bold, Italics, Underline and Font colour.<\/p>\n","protected":false},"excerpt":{"rendered":"

One of the first things most Excel users quickly discover is how to change the font, font size and colour of text in cell. However, you may not have discovered …<\/p>\n","protected":false},"author":4,"featured_media":237,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-422","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"\nFormat only some of the text in an Excel cell - Alandale Training Software Tips<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.alandaletraining.com\/software-tips\/2018\/10\/17\/format-only-some-of-the-text-in-an-excel-cell\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Format only some of the text in an Excel cell - Alandale Training Software Tips\" \/>\n<meta property=\"og:description\" content=\"One of the first things most Excel users quickly discover is how to change the font, font size and colour of text in cell. However, you may not have discovered ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.alandaletraining.com\/software-tips\/2018\/10\/17\/format-only-some-of-the-text-in-an-excel-cell\/\" \/>\n<meta property=\"og:site_name\" content=\"Alandale Training Software Tips\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-17T01:49:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2017\/03\/Laptop-1024x683.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"683\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"John Chandler\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John Chandler\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Format only some of the text in an Excel cell - Alandale Training Software Tips","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/10\/17\/format-only-some-of-the-text-in-an-excel-cell\/","og_locale":"en_US","og_type":"article","og_title":"Format only some of the text in an Excel cell - Alandale Training Software Tips","og_description":"One of the first things most Excel users quickly discover is how to change the font, font size and colour of text in cell. However, you may not have discovered ...","og_url":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/10\/17\/format-only-some-of-the-text-in-an-excel-cell\/","og_site_name":"Alandale Training Software Tips","article_published_time":"2018-10-17T01:49:07+00:00","og_image":[{"width":1024,"height":683,"url":"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2017\/03\/Laptop-1024x683.jpeg","type":"image\/jpeg"}],"author":"John Chandler","twitter_card":"summary_large_image","twitter_misc":{"Written by":"John Chandler","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/10\/17\/format-only-some-of-the-text-in-an-excel-cell\/#article","isPartOf":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/10\/17\/format-only-some-of-the-text-in-an-excel-cell\/"},"author":{"name":"John Chandler","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/4354e1f8ae425698db32a15825a8ecb4"},"headline":"Format only some of the text in an Excel cell","datePublished":"2018-10-17T01:49:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/10\/17\/format-only-some-of-the-text-in-an-excel-cell\/"},"wordCount":150,"image":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/10\/17\/format-only-some-of-the-text-in-an-excel-cell\/#primaryimage"},"thumbnailUrl":"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2017\/03\/Laptop.jpeg","articleSection":["Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/10\/17\/format-only-some-of-the-text-in-an-excel-cell\/","url":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/10\/17\/format-only-some-of-the-text-in-an-excel-cell\/","name":"Format only some of the text in an Excel cell - Alandale Training Software Tips","isPartOf":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/10\/17\/format-only-some-of-the-text-in-an-excel-cell\/#primaryimage"},"image":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/10\/17\/format-only-some-of-the-text-in-an-excel-cell\/#primaryimage"},"thumbnailUrl":"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2017\/03\/Laptop.jpeg","datePublished":"2018-10-17T01:49:07+00:00","author":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/4354e1f8ae425698db32a15825a8ecb4"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.alandaletraining.com\/software-tips\/2018\/10\/17\/format-only-some-of-the-text-in-an-excel-cell\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/10\/17\/format-only-some-of-the-text-in-an-excel-cell\/#primaryimage","url":"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2017\/03\/Laptop.jpeg","contentUrl":"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2017\/03\/Laptop.jpeg","width":4000,"height":2667,"caption":"modern red small netbook with gray keyboard"},{"@type":"WebSite","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#website","url":"https:\/\/www.alandaletraining.com\/software-tips\/","name":"Alandale Training Software Tips","description":"Weekly Software Tips","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.alandaletraining.com\/software-tips\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/4354e1f8ae425698db32a15825a8ecb4","name":"John Chandler","sameAs":["http:\/\/AlandaleTraining.com"],"url":"https:\/\/www.alandaletraining.com\/software-tips\/author\/john1973\/"}]}},"_links":{"self":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/422","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/comments?post=422"}],"version-history":[{"count":1,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/422\/revisions"}],"predecessor-version":[{"id":423,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/422\/revisions\/423"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/media\/237"}],"wp:attachment":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/media?parent=422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/categories?post=422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/tags?post=422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}