Excel offers simple methods to switch between viewing results and viewing formulas. Here is how to display formulas in Excel.

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.