Launch Microsoft Excel. Create a table or use an existing table from your files. Place the formula into the cell you want to see the result. Press the Enter Key. Launch Microsoft Excel. Create a table ...

It may be needed that you want to type multiple lines of text a particular cell. The main concern lies in the fact that under Excel when you press the Enter Key, the cursor will move to the next cell.

You'll want to add this quick selection trick to your repertoire. It's handy when the range isn't a complete data range or it comprises more than one data range. You probably know about the [F5] key – ...