Here are three different ways to enter data or formulas into a range of cells in Excel:
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
The three ways you can enter data into a data range are:
1) Type in the data => Using the Auto Fill handle, drag it across the columns => Drag it down the rows
2) Highlight the data range first => Type in the data => Instead of hitting Enter, use Ctrl + Enter (hold down the Ctrl key while you hit Enter)
3) Type in the data => Highlight the data range => Hit the F2 key to put it into the Edit mode => Use Ctrl + Enter (hold down the Ctrl key while you hit Enter)