Type some names into cells B3, B4, B5, and B6 (for example, Julie, Nancy, Sid, and Jasmel) and press Enter.
In cell B7, type the first letter of one of the original four names for example, S. The name Sid automatically fills the cell. Press Enter to accept the entry.
In cell B8, type the first letter of another name for example, J. No name automatically fills the cell because the inferred name could be either Julie or Jasmel.
Type the second letter of the name for example, u. The name Julie appears. Press either the Enter or the down-arrow key to enter the name into the cell.
INTRODUCTION
Sometimes you'll find that you are entering the same text-based data in multiple cells in the same row or column. To save time, Excel tries to infer the data you want to enter (only for text entries, not numbers).
TIP
Overriding Excel's Entry
Suppose cell B3 contains the text paper clips, cell B4 contains pencils, and you want to type paper in cell B5. When you do, Excel automatically enters Paper clips in the cell. To ensure the cell holds only the data you want, simply continue to type the word paper and press the Delete key on the keyboard when you finish. The rest of the text disappears; press Enter and move on to your next cell entry.