Q5: How do I change caps to lowercase without retyping? A5: You can change uppercase text to lowercase in Excel without retyping by using the “Find and Replace” feature. Open the “Find and Replace” dialog (Ctrl + H), enter the uppercase text in the “Find what” field, and ent...
Choose the macro of which you want to edit the shortcut key. Click on theOptionsas marked in the image given below. TheMacro Optionsdialog box will open. Edit theShortcut keyaccording to your preference. We changed the shortcut key toCtrl + R(lowercase R). Click onOK. You will be red...