To turn on the AutoComplete option : AutoComplete « Editing « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Editing
  3. AutoComplete
Click the Office button. Click Excel Options.
Click the Office button. Click Excel Options.
Click Advanced. Select Enable AutoComplete for cell values.
Click Advanced. Select Enable AutoComplete for cell values.
Click OK.
Click OK.
2.20.AutoComplete
2.20.1.Enter a Label Using AutoCompleteEnter a Label Using AutoComplete
2.20.2.To turn on the AutoComplete optionTo turn on the AutoComplete option