Chapter 3. Entering Data

Entering Data

Excel worksheets can hold all kinds of data, ranging from numbers and text to formulas and functions. This chapter shows you various ways to enter data, including several Excel features for speeding up data entry tasks.

Enter Data

You can enter data into any cell within the worksheet. When you click a cell, it immediately becomes the active cell in the worksheet, and any data you type appears within it. 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 in Excel. Formulas are also values. Excel automatically ...

Get Teach Yourself VISUALLY™: Excel® 2007 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.