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

➪

Tables

➪

Table).

Figure 13.7 shows an example.

FIGURE 13.7

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.