{"id":3493,"date":"2018-11-24T15:33:14","date_gmt":"2018-11-24T15:33:14","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3493"},"modified":"2024-03-28T13:49:30","modified_gmt":"2024-03-28T13:49:30","slug":"change-lowercase-to-uppercase","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/","title":{"rendered":"Shortcut Key for Uppercase in Excel"},"content":{"rendered":"\n

Contrary to Word, Excel offers less advanced features when it comes to text modification. For example, there is no Change Case<\/strong> button.<\/p>\n\n\n\n

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

We shouldn\u2019t be surprised by that, Excel is not a word processor. But sometimes you really need this feature, especially if you have to deal with a large amount of data.<\/p>\n\n\n\n

In this lesson, I\u2019m going to show you a few simple ways you can convert lowercase, or mixed case sentences into all caps.<\/p>\n\n\n\n

All caps with formula<\/h2>\n\n\n\n

The UPPER<\/a> formula changes every letter inside a cell to uppercase. It doesn\u2019t matter what is the combination of small caps and large caps, it changes it all to uppercase.<\/p>\n\n\n\n

=UPPER(A2)<\/pre>\n\n\n\n

Here, you have some examples, of how this function behaves.<\/p>\n\n\n\n

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

All caps without formula<\/h2>\n\n\n\n

If you don\u2019t want to use a formula, you can create VBA code that will convert selected cells to uppercase within the selected cells. Here is the code.<\/p>\n\n\n\n

Open the VBA Editor by using Left Alt + F11<\/strong>, and insert the following code.<\/p>\n\n\n\n

Sub AllCaps()\n    For Each Cell In Selection\n        If Not Cell.HasFormula Then\n            Cell.Value = UCase(Cell.Value)\n        End If\n    Next Cell\nEnd Sub\n<\/pre>\n\n\n\n

This is the result, you will get.<\/p>\n\n\n\n

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

Shortcut icon<\/h2>\n\n\n\n

In order to create a shortcut icon for our subroutine, you have to click the Customize Quick Access Toolbar<\/strong> icon.<\/p>\n\n\n\n

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

From there, select the More Commands<\/strong> option.<\/p>\n\n\n\n

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

Under the drop-down Choose commands from<\/strong> select Macros and select our AllCaps<\/strong> macro. Click Add >><\/strong> button. Now the macro is visible in Quick Access Toolbar.<\/p>\n\n\n\n

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

You can keep it this way. But I suggest changing the icon, especially if you create other shortcuts from macros. I chose the following icon, but you can choose any icon you want.<\/p>\n\n\n\n

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

Now, if you want to change the text to all caps, you can select the cells you want to modify and click the icon in the Quick Access Toolbar<\/a>.<\/p>\n\n\n\n

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

Keyboard shortcut<\/h2>\n\n\n\n

In addition to the icon, you can also add a keyboard shortcut to our macro.<\/p>\n\n\n\n

Open your PERSONAL.XLSB workbook and click View >> Macros >> View Macros<\/strong>.<\/p>\n\n\n\n

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

A new window called Macro will appear. Click the AllCaps<\/strong> subroutine and then click Options<\/strong>.<\/p>\n\n\n\n

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

Inside a new window, under the Shortcut key,<\/strong> there is a little text area. Click inside it and press Shift + A<\/strong>. This will assign Ctrl + Shift + A<\/strong> button to the macro.<\/p>\n\n\n\n

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

Select the cells you want to convert to uppercase and press the keyboard shortcut you\u2019ve just created. You can also use other shortcuts, but remember that it will override the default Excel shortcut. Be sure you don\u2019t use it for other tasks.<\/p>\n\n\n\n

Free plugin<\/h2>\n\n\n\n

You can also change the text to uppercase by using a free plugin for SEO<\/a>. Just select the text you want to change and click the button (SEO >> Text >> Change Case >> Upper Case<\/strong>).<\/p>\n\n\n\n

After you click it, the text will automatically change to uppercase.<\/p>\n\n\n\n

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

Contrary to Word, Excel offers less advanced features when it comes to text modification. For example, there is no Change Case button. We…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[190,150],"yoast_head":"\nShortcut Key for Uppercase in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to convert lowercase or mixed case sentences into all caps in Excel. Use the UPPER formula or VBA code for selected cells without a formula.\" \/>\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\/examples\/change-lowercase-to-uppercase\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Shortcut Key for Uppercase in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to convert lowercase or mixed case sentences into all caps in Excel. Use the UPPER formula or VBA code for selected cells without a formula.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-24T15:33:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T13:49:30+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/change-case-button.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\/examples\/change-lowercase-to-uppercase\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Shortcut Key for Uppercase in Excel\",\"datePublished\":\"2018-11-24T15:33:14+00:00\",\"dateModified\":\"2024-03-28T13:49:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/\"},\"wordCount\":475,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/change-case-button.png\",\"keywords\":[\"pinterest\",\"SEO\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/\",\"name\":\"Shortcut Key for Uppercase in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/change-case-button.png\",\"datePublished\":\"2018-11-24T15:33:14+00:00\",\"dateModified\":\"2024-03-28T13:49:30+00:00\",\"description\":\"Learn how to convert lowercase or mixed case sentences into all caps in Excel. Use the UPPER formula or VBA code for selected cells without a formula.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/change-case-button.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/change-case-button.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Shortcut Key for Uppercase in Excel\"}]},{\"@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":"Shortcut Key for Uppercase in Excel","description":"Learn how to convert lowercase or mixed case sentences into all caps in Excel. Use the UPPER formula or VBA code for selected cells without a formula.","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\/examples\/change-lowercase-to-uppercase\/","og_locale":"en_US","og_type":"article","og_title":"Shortcut Key for Uppercase in Excel","og_description":"Learn how to convert lowercase or mixed case sentences into all caps in Excel. Use the UPPER formula or VBA code for selected cells without a formula.","og_url":"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/","article_published_time":"2018-11-24T15:33:14+00:00","article_modified_time":"2024-03-28T13:49:30+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/change-case-button.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\/examples\/change-lowercase-to-uppercase\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Shortcut Key for Uppercase in Excel","datePublished":"2018-11-24T15:33:14+00:00","dateModified":"2024-03-28T13:49:30+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/"},"wordCount":475,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/change-case-button.png","keywords":["pinterest","SEO"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/","url":"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/","name":"Shortcut Key for Uppercase in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/change-case-button.png","datePublished":"2018-11-24T15:33:14+00:00","dateModified":"2024-03-28T13:49:30+00:00","description":"Learn how to convert lowercase or mixed case sentences into all caps in Excel. Use the UPPER formula or VBA code for selected cells without a formula.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/change-case-button.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/change-case-button.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/change-lowercase-to-uppercase\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Shortcut Key for Uppercase in Excel"}]},{"@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\/3493"}],"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=3493"}],"version-history":[{"count":8,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3493\/revisions"}],"predecessor-version":[{"id":12866,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3493\/revisions\/12866"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=3493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=3493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=3493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}