Page 88 - Excel 2007 Bible

07_044039 ch03.qxp 11/21/06 10:55 AM Page 45
Entering and Editing Worksheet Data
FIGURE 3.6
AutoCorrect allows you to create shorthand abbreviations for text you enter often.
TIP
TIP Excel shares your AutoCorrect list with other Office applications. For example, any 3
AutoCorrect entries you created in Word also work in Excel.
Entering numbers with fractions
To enter a fractional value into a cell, leave a space between the whole number and the fraction. For exam-
7
ple, to enter 6 ⁄8, enter 6 7/8 and then press Enter. When you select the cell, 6.875 appears in the Formula
bar, and the cell entry appears as a fraction. If you have a fraction only (for example, ⁄8), you must enter a
1
zero first, like this: 0 1/8 — otherwise, Excel will likely assume that you’re entering a date. When you select
1
the cell and look at the Formula bar, you see 0.125. In the cell, you see ⁄8.
Simplifying data entry by using a form
Many people use Excel to manage lists in which the information is arranged in rows. Excel offers a simple
way to work with this type of data through the use of a data entry form that Excel can create automatically.
This data form works with either a normal range of data, or with a range that has been designated as a table
(choosing Insert ➪ Tables ➪ Table). Figure 3.7 shows an example.

45