Entering Stuff

Excel accepts two basic types of cell entries: constants and formulas. Constants fall into three main categories: numeric values, text values (also called labels or strings), and date/time values. Excel also recognizes two special types of constants called logical values and error values.

Cross Reference

For more on date values, see Chapter 15.

Making Entries in Cells and in the Formula Bar

To make an entry into a cell, just select the cell and start typing. As you type, the entry appears both in the formula bar and in the active cell. The flashing vertical bar in the active cell is called the insertion point.

After you finish typing, you must "lock in" the entry to store it permanently in the cell by pressing Enter. Pressing Enter normally ...

Get Microsoft® Office Excel 2003 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.