Autocomplete with Excel

ole · Joined: 11 Dec 2005 Posts: 207

Hello people. I have to populate very large spreadsheet in Microsoft Excel 2003. Many entries are repeating but without any order. It is really troublesome to type them over and over again. I think that autocomplete feature will be of great help here but I am not able to find anything similar in Excel. Can you tell me what should I do to enable it if it exists?

corbie · Joined: 22 Jun 2007 Posts: 107

Hello friend. There is autocomplete feature in Microsoft Excel. To turn it on you should go to Tools menu, click Options and then click Edit tab. Check “Enable AutoComplete for cell values” check box. Now Excel will try to match entries in this column based on few first characters you type. Remember that this works only in for one column and autocomplete will not try to match entries from different columns.

H-Desk.com - PC Security matters - Protect your PC privacy

Autocomplete with Excel

LIFEFORM SOCIAL COMMUNITY NETWORK