Click the Office button. Click Excel Options. Click Advanced. Select Enable AutoComplete for cell values. Click OK.