Teach Yourself VISUALLY Microsoft 365

CHAPTER 9

Building Spreadsheets

Enter Cell Data

You can enter data into any cell in an Excel worksheet. You can type data directly into the cell, or you can enter data using the Formula bar. Data can be text, such as row or column labels, or numbers, which are called values. Values also include formulas. Excel automatically left-aligns text data in a cell and right-aligns values.

Long text entries appear truncated if you type additional data into adjoining cells. Values too large to fit in a cell might be represented by a series of pound signs. However, Excel offers features to help you remedy these situations.

Enter Cell Data

Type into a Cell

Click the cell into which you want to enter data.

The cell you clicked is called the active cell. It has a thicker border around it than the other cells.

To magnify your view of the worksheet, click and drag the Zoom slider.

Type your data.

The data appears both in the cell and in the Formula bar.

To store the data in the cell, press ...