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. But, Excel offers features to help you remedy these situations.

Enter Cell Data

image

Type into a Cell ...

Get Teach Yourself VISUALLY Office 2016 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.