Step 5: In the opened window, please select ‘ConvertToLowerCase’ from the drop-down list. Step 4: Now, to assign the code to the command button, click on the ‘View Code’ command in the ‘Controls’ group in ‘Developer’ Make sure ‘Design Mode’ is activated. Step 3: Using the ‘Properties’ command, change the properties of the command button like caption, name, AutoSize, WordWrap, etc. We can resize the command button using the ALT button. Step 2: Click the worksheet location at which you want the command button to appear. read more.’ And select the ‘Command Button.’ This tab is disabled by default on excel thus, the user needs to enable it first from the options menu. Step 1: To create the command button, click on the ‘Insert’ command in the ‘Controls’ group in the ‘ Developer tab Excel Developer Tab Excel Enabling the developer tab in excel can help the user perform various functions for VBA, Macros and Add-ins like importing and exporting XML, designing forms, etc. We can create a VBA command button and assign the code to change the following text to lowercase using the command button. Or we can drag the formula in other cells to get the answer. For other values, we can either press Ctrl+D after selecting all the cells with top cell or press Ctrl+C and Ctrl+V for copying and pasting the function. Press Enter, and this function will convert all letters in a text string to lowercase. read more for the text for which we want to change the case. For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1. ”=’ or ‘+’ sign is used to write the function, ‘LOWER’ is the function name and A2 is the cell reference Cell Reference Cell reference in excel is referring the other cells to a cell to use its values or properties. To change the case to lower, we need to write the function in cell C2 as ‘=LOWER(A2)’. Suppose we have a list of some verbs in excel, we want to change the case of text to lowercase. There is a built-in function in MS Excel for decapitalizing each character in a word, which is a LOWER function. You can download this LowerCase Excel Template here – LowerCase Excel Template #1 Using Lower Function to change case in Excel

Automatically change case in word