You can greatly streamline the process if. You are able to easily record a Macro in Word or Excel that will allow you to capitalize selection or rane being it a paragraph, column, cell etc’. One of the most common word processing chores is changing the case of text in a document. Word and Excel change case with VBA Macros Couple readers asked whether it would be possible to automate case change with VBA Macros. Text selected to be formatted with a heading style. Change case in your Word documents with easy toggle shortcuts. Press Ctrl + V or right-click on the blank page and select the Paste option from the context menu. Press Ctrl + C or right-click on the selection and choose the Copy option from the context menu. (Or, move your cursor to a blank line where you want to type your new heading during the next step.) Figure 2. Select the range where you want to change case in Excel. All we have to do is to follow the steps described below First, we select the text. Microsoft Word has a handy function to change case, and if you wanted to change it all - this is what you do:Ģ. Select the text you want to turn into a heading. In a Word Document, we can change the capitalization of text with a single click very easily and very quickly. Functions are just built-in formulas that are designed to accomplish specific tasksin this case, converting text case. However, you can use the UPPER, LOWER, or PROPER functions to automatically change the case of existing text to uppercase, lowercase, or proper case.
![change case in word 2013 change case in word 2013](https://image.slidesharecdn.com/word20138-140929075336-phpapp02/95/word-2013-8-6-638.jpg)
![change case in word 2013 change case in word 2013](https://www.computerhope.com/issues/pictures/changecase_icon_word.jpg)
So what do you do if you receive a document of 7 pages all typed in capital letters? Unlike Microsoft Word, Microsoft Excel doesnt have a Change Case button for changing capitalization.
![change case in word 2013 change case in word 2013](https://easykey.uk/images/help/excel/excel-paste-value.jpg)
Have you ever inherited a Word document all typed out in CAPITAL LETTERS?Īccording to the Equality Act text in CAPITAL LETTERS is more difficult to read as letters are harder to recognise.