AutoComplete Feature

The AutoComplete feature in Excel 2007 anticipates what you might want to enter next based upon text you just entered.
AutoComplete comes into play only when you’re entering a column of text entries.

For example, if I type cola in cell A1, beer in cell A2, then Excel will propose the word beer, when I type b in cell A3.
If I want beer, I can click the Enter key and AutoComplete inserts the remainder of the text in this cell.
For any other word, I have to type it completely.

For the AutoComplete Feature to work there is one condition, there should be no empty cells in our list.
Suppose you leave cell A3 empty and you type b in cell A4, Excel will not auto-complete.

If you do not want to use this feature you can disable it.

Click the “Office” button, select “Excel Options” and choose the “Advanced” tab.

In the list uncheck the check box “Enable Auto complete for cell values”.

A second way is to right click the cell and select “Pick from drop-down list.”

This opens a list of all previous typed values and you choose the one you want.

The only condition here is also that there are no empty cell (s) in the list.

 

 

 

The autocompletion only works for text and text with numbers.
This does not work for numbers, dates and time.

 

Modifying Cell data

If we have typed errors, or we have to modify data in a cell, we do not have to retype the whole text.
There are several ways to change the text:

 

• The first way is to select the cell and click the F2 key on your keyboard.

 

• A second way is to select the cell and change the text in the formula bar.

 

• A third way is to double-click the cell.

It doesn’t matter how you do it.

Click the Enter button to confirm your changes.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats