To change small letters to capital letters in Excel, use the formula =UPPER(cell_reference). For example, if the small letters are in cell A2, type =UPPER(A2) in another cell, then press Enter. This will convert the text in A2 to all uppercase letters. Afterward, you can copy the formula down for other cells, and if you want to keep only the capitalized text values (not the formula), copy the results and then use "Paste Values" to overwrite the original data.

Steps to change small letters to capital letters in Excel:

• Insert a new column next to the column with the text.
• In the first cell of the new column, type =UPPER(A2) (replace A2 with the appropriate cell).
• Press Enter to convert the text to uppercase.
• Drag the fill handle down to apply the formula to other rows.
• Copy the new column, right-click the original column, and choose Paste > Values to replace the original text with uppercase text.
• Delete the helper column if no longer needed.

There is also a keyboard shortcut (Shift + F3) to toggle through text cases in Excel cells, but it's mainly for selected text within a cell in Excel 365 or Word. These methods are supported by official Microsoft documentation and community tutorials.