Type the formula =UPPER(XX) but replace the XX with the cell location of the currently-lowercase text.Click inside the cell where you want the uppercase text.Quick Summary – How to Make All Text Uppercase in Excel So continue below to see the steps that you need to take to convert text in your worksheet from lowercase to uppercase. Using all uppercase case in Excel 2010 is a great way to make the letters stand out from the numbers and, in many situations, it simply makes the data in the spreadsheet easier to read. One of those times in when you are entering information into a spreadsheet. Despite the annoyance that many people have for caps lock and people that write in all uppercase letters, it does have its’ place in certain situations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |