Microsoft Office Tutorials and References
In Depth Information
Learning some handy data-entry techniques
Entering numbers with fractions
To enter a fractional value into a cell, leave a space between the whole number and the
fraction. For example, to enter 6 7/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, 1/8), you must enter a zero ﬁ rst, like this — 0 1/8 — or Excel
will likely assume that you’re entering a date. When you select the cell and look at the
Formula bar, you see 0.125. In the cell, you see 1/8.
Using a form for data entry
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 (choose Insert
Figure 13.7 shows an example.
Excel’s built-in data form can simplify many data-entry tasks.
Unfortunately, the command to access the data form is not on the Ribbon. To use the data
form, you must add it to your Quick Access Toolbar or add it to the Ribbon. The following
instructions describe how to add this command to your Quick Access Toolbar:
1. Right-click the Quick Access Toolbar and choose Customize Quick Access
Toolbar. The Quick Access Toolbar panel of the Excel Options dialog box appears.
2. In the Choose commands from drop-down list, choose Commands Not in the Ribbon.