#HOW TO PUT A NAME IN SMALL CAPS IN WORD HOW TO#
#HOW TO PUT A NAME IN SMALL CAPS IN WORD PROFESSIONAL#

Step 5: Press Ctrl + V on your keyboard to paste your copied function into these cells. Step 4: Click in the cell underneath the cell that you just copied, then drag your mouse down to select the number of cells that correspond to the number of cells that you want to convert to uppercase. Step 3: Click the cell into which you just typed this function, then press Ctrl + C on your keyboard to copy it. Replace XX with the cell location of the top cell in the column you want to convert. Step 2: Type =UPPER(XX) into the topmost empty cell, then press Enter on your keyboard. For example, if you wanted to convert cells A1-A5 to uppercase, then you would need a column with five empty cells. Step 2: Locate an empty group of cells in your spreadsheet that corresponds to the amount of cells containing text that you want to convert to uppercase. Step 1: Double-click the Excel file that contains the text that you want to convert.

#HOW TO PUT A NAME IN SMALL CAPS IN WORD HOW TO#

So follow the steps below to learn how to convert text in your spreadsheet to uppercase.

#HOW TO PUT A NAME IN SMALL CAPS IN WORD PROFESSIONAL#

In fact, you could make the argument that exclusive use of uppercase letters in Excel 2010 spreadsheets actually looks more professional than standard case usage. While capital letters and the upper case are poor practice in texting and other forms of written communication, they are useful when confined to situations where someone is not being addressed specifically.

Copy and paste the formula cell into each other cell in your column if you wish to make the rest of the cells in a column uppercase.Д¬onvert to All Capital Letters in Excel 2010.

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.

How to put a name in small caps in word