The easiest way to capitalize text in Excel is by using the PROPER function. It capitalizes the first letter of each word in a text string while converting all other letters to lowercase.

The list appears when you type something related to a formula. For example, check out the following image- As the text starts with =, Excel starts showing the formulas in a list format.