Share this Page URL

Hour 7. Excel 2002 Workbooks > Entering Worksheet Data - Pg. 91

Excel 2002 Workbooks 91 Figure 7.2. Your Excel worksheets don't have to appear dull and boring. Entering Worksheet Data Often, entering worksheet data requires nothing more than clicking the correct cell to select it and then typing the data. The various kinds of data behave differently when entered, however, so you should understand how Excel accepts assorted data. Excel can work with the following kinds of data: · Labels--Text values such as names and addresses, as well as date and time values · Numbers--Numeric values such as 34, ­291, 545.67874, and 0 · Formulas--Expressions that compute numeric results (some formulas work with text values as well) Excel also works well with data from other Office XP products as well as integrate into the online Internet world by supporting hyperlinks that you can embed into your worksheets. Additionally, you can import (transfer) data from other non-Microsoft products, such as Lotus 1-2-3. Entering Text If you want to put text (such as a title or a name) in a cell, just click the cell to select it and then type the text. By default, Excel left-justifies the text in the cell. As you type, the text appears both in the cell and in the Formula bar (see Figure 7.3). Remember that the Name Box to the left of the Formula bar displays the name of the cell into which you are entering data. When you press Enter, Excel moves the cell pointer down one row. In addition to pressing Enter, you can click the Enter button (indicated by a green checkmark) to the right of the Name Box to keep the current cell selected or press one of the arrow keys or the Tab key to move the cell pointer to a different cell adjacent to the current one.