Entering Data

Learning Objectives

  • Add data to a table.

Excel workbooks are used to organize data very clearly. Numerical data can be used in a variety of ways, some of which we will examine in later modules. The first step, however, is simply to enter data into a table.

First, open a blank workbook. Next, click on the first cell for your data: this will almost always be A1.

A blank Microsoft Excel sheet is open. There is a green box surrounding the first cell which is A1.

If you wish to organize your data in a column, you will hit ENTER to move to the next cell down. In this case, A2.

A blank Microsoft Excel sheet is open. There is a green pointing downward signaling a transition of rows from cell A1 to cell A2.

If you wish to organize your data in a row, you will hit the Tab key to move to the next cell over. In this case, the next cell over is B1.

A blank Microsoft Excel sheet is open. There is a green arrow pointing to the right indicating moving columns from A1 to B1.

Enter all of your data into each individual cell until you are ready to save your workbook.

Practice Question

Check Your Understanding

Answer the question(s) below to see how well you understand the topics covered in the previous section. This short quiz does not count toward your grade in the class, and you can retake it an unlimited number of times.

Use this quiz to check your understanding and decide whether to (1) study the previous section further or (2) move on to the next section.