{"id":472,"date":"2018-06-28T09:37:25","date_gmt":"2018-06-28T09:37:25","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=472"},"modified":"2024-03-30T00:38:46","modified_gmt":"2024-03-30T00:38:46","slug":"bold-italic-underline-and-strikethrough","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/","title":{"rendered":"Bold, Italic, Underline, and Strikethrough"},"content":{"rendered":"\n

Besides changing the color, size and font type, you can highlight text in Excel in several different ways. For example, using: bold (Ctrl + B<\/span>)<\/strong>, italic (Ctrl + I<\/span>)<\/strong>, underline (Ctrl + U<\/span>)<\/strong>, and strikethrough.<\/strong><\/p>\n\n\n\n

Bold and italic<\/h2>\n\n\n\n

Many fonts have a few different variations, such as regular, bold and italic. If a font has only a regular type<\/a>, then Excel creates the other two by using its own algorithm.<\/p>\n\n\n\n

You can find the bold and italic buttons in HOME >> Font<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You can combine them or use them separately. As a result, the text can be written in italics, bold, or bold italics.<\/p>\n\n\n\n

Underline<\/h2>\n\n\n\n

You will find the underline button on the right side of the bold and italic buttons.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

When you click the triangle you will have a choice whether you want your text to be Underlined<\/strong> or Double Underlined<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In addition to the standard underline, you can also use the Accounting Underline<\/strong>. You won\u2019t find it directly in the ribbon<\/a>, so you have to click the little square icon in the lower right corner of the font group.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You can also use the Ctrl + Shift + F<\/span><\/strong> keyboard shortcut.<\/p>\n\n\n\n

When a new window opens, select from the drop-down list the Single Accounting<\/strong> or Double Accounting <\/strong>underline.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

There are two differences between the standard underline and the accounting underline:<\/p>\n\n\n\n

    \n
  1. In the accounting underline, the whole text is placed above the line. In the standard underline parts of some letters can be under the line.<\/li>\n\n\n\n
  2. In the accounting underline, the line is stretched across the width of the cell, while in the standard underline the width of the line is equal to the width of the text.<\/li>\n<\/ol>\n\n\n\n

    Strikethrough<\/h2>\n\n\n\n

    In order to use the strikethrough, select text and use the Ctrl + Shift + F<\/span><\/strong> keyboard shortcut.<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    In the Effects area check strikethrough,<\/strong> click OK<\/strong> and see the effect.<\/p>\n\n\n\n

    \"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

    Besides changing the color, size and font type, you can highlight text in Excel in several different ways. For example, using: bold (Ctrl +…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[190],"yoast_head":"\nBold, Italic, Underline, and Strikethrough<\/title>\n<meta name=\"description\" content=\"Learn how to highlight text in Excel using bold, italic, underline, and strikethrough. Discover the different variations and shortcuts for each option.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bold, Italic, Underline, and Strikethrough\" \/>\n<meta property=\"og:description\" content=\"Learn how to highlight text in Excel using bold, italic, underline, and strikethrough. Discover the different variations and shortcuts for each option.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-28T09:37:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-30T00:38:46+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/font.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Bold, Italic, Underline, and Strikethrough\",\"datePublished\":\"2018-06-28T09:37:25+00:00\",\"dateModified\":\"2024-03-30T00:38:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/\"},\"wordCount\":332,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/font.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"training\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/\",\"url\":\"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/\",\"name\":\"Bold, Italic, Underline, and Strikethrough\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/font.png\",\"datePublished\":\"2018-06-28T09:37:25+00:00\",\"dateModified\":\"2024-03-30T00:38:46+00:00\",\"description\":\"Learn how to highlight text in Excel using bold, italic, underline, and strikethrough. Discover the different variations and shortcuts for each option.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/font.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/font.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bold, Italic, Underline, and Strikethrough\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bold, Italic, Underline, and Strikethrough","description":"Learn how to highlight text in Excel using bold, italic, underline, and strikethrough. Discover the different variations and shortcuts for each option.","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:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/","og_locale":"en_US","og_type":"article","og_title":"Bold, Italic, Underline, and Strikethrough","og_description":"Learn how to highlight text in Excel using bold, italic, underline, and strikethrough. Discover the different variations and shortcuts for each option.","og_url":"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/","article_published_time":"2018-06-28T09:37:25+00:00","article_modified_time":"2024-03-30T00:38:46+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/font.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Bold, Italic, Underline, and Strikethrough","datePublished":"2018-06-28T09:37:25+00:00","dateModified":"2024-03-30T00:38:46+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/"},"wordCount":332,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/font.png","keywords":["pinterest"],"articleSection":["training"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/","url":"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/","name":"Bold, Italic, Underline, and Strikethrough","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/font.png","datePublished":"2018-06-28T09:37:25+00:00","dateModified":"2024-03-30T00:38:46+00:00","description":"Learn how to highlight text in Excel using bold, italic, underline, and strikethrough. Discover the different variations and shortcuts for each option.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/font.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/font.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/training\/bold-italic-underline-and-strikethrough\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Bold, Italic, Underline, and Strikethrough"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/472"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=472"}],"version-history":[{"count":5,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/472\/revisions"}],"predecessor-version":[{"id":13241,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/472\/revisions\/13241"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}