We need to select the AllCaps macro from the list and click the Modify button to add a custom icon for the shortcut. After clicking the Add > button, we will see that the AllCaps macro is added to the list on the right side box.We need to select Macros from the list under 'Choose commands from' and click the AllCaps macro that we added with the VBA editor in the next window.Īlso, we need to click the Add > button, as shown below:.We need to select the More Commands option from the list:.After that, we need to click the Customize Quick Access Toolbar drop-down icon, as shown below:.We need to save the VBA script and close the editor.
#Excel text to uppercase code#
Next, we need to go to the Insert > Module and copy-paste the following code into the VBA editor:.We might also need to press the Fn key for some keyboards before pressing F11 to activate the function keys. To open the VBA editor in Excel, we must simultaneously press the shortcut keys Left Alt + F11. First, we need to launch the VBA editor to insert the script/ code.Let us perform the necessary steps to configure the uppercase shortcut in the quick access toolbar: Therefore, we must first insert a VBA code to convert selected cells to uppercase and then create a shortcut to use this script from the shortcut. However, we cannot add the shortcut for uppercase like adding any other general shortcut or feature, and it is because there is no built-in uppercase option in Excel. To use the uppercase shortcut from the quick access toolbar, we have to add it first on the toolbar. Shortcut 1: Uppercase Shortcut in Quick Access Toolbar Having a backup will help us recover our data easily. This is necessary for those scenarios when we mess with the data while trying the steps. Let us understand each shortcut in detail: Note: It is highly recommended to back up the original file before changing or converting the text to lowercase. We can leverage any of the above uppercase shortcuts and change small and mixed caps to complete uppercase. Uppercase Shortcut in Quick Access Toolbar.However, we have two significant alternate Uppercase Shortcuts in Excel, as listed below: Although it works perfectly, it is not as fast as using the shortcuts in Excel for other features. The UPPER formula changes every letter inside specific cells to uppercase. Since Excel lacks a quick shortcut button to use the uppercase, we need to use the UPPER formula to change the data to uppercase in Excel. Besides, in Excel, we need uppercase for some specific type of data, such as names, IDs, etc. Because if we type everything in all uppercase in Word, it looks like we are yelling and making it hard to read for the readers. However, the feature is way more needed in Excel than MS Word. Unfortunately, Excel lacks this feature as built-in options or direct tool/ shortcut. In MS Word, the case feature shortcut is given on ribbon that helps users to change between different cases easily, as shown below: Alternately, we can press the character keys while holding the Shift key to make text capital. When we need to type in uppercase, we typically use the caps lock button to enter everything in all caps.
Besides, when we type A, B and C, it represents the uppercase letters. It is also known as Caps, AllCaps, and Capital.įor example, if we type a, b, and c, it represents the lowercase letters or characters. The uppercase feature is defined as a typeface of larger characters while typing anything in the Word processing software. What is the uppercase feature, and what is its use? But before we discuss the shortcuts, let us take a quick overview of the uppercase option and its importance in text modification. This article discusses some alternate shortcuts to use uppercase in Excel to convert lowercase or mixed case data into all-caps. If we edit all the names one by one, it becomes a tedious task, especially when dealing with vast amounts of data. For instance, we may have to change some names from lowercase to uppercase. Sometimes, we may typically need the Change Case feature to adjust the text presentation accordingly. For instance, Excel has no direct option or shortcut key to use Change Case (such as uppercase, lowercase, etc.) feature like MS Word.Įven though Excel is not known as word processing software, we have to deal with the text data and sentences within the Excel cells. Although it offers numerous advanced features, it lacks some essential features when we think of text modification.
#Excel text to uppercase software#
MS Excel is one of the most powerful spreadsheet software with a distinct range of features. Next → ← prev Uppercase Shortcut in Excel
0 kommentar(er)
