Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training - Data entry
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
ms excel training - Data entry
Resolved · Low Priority · Version Standard
Reply Thu 21 Jun 2007, 15:17Delegate James said...
James has attended:
Excel Intermediate course
Outlook Advanced course
Access Advanced course
Excel Advanced course
Outlook Advanced course
Data entry
I enter alot of repeated data. Sometimes, excel see's the first few letters I type and enters what it thinks I am going to type, and it's great because excel is usually correct. Sometimes, excel does not do this and I would like to know why this is so I can make it happen all the time. Thanks
For upcoming training course dates see: Pricing & availability
RE: data entry
Hi James
Thanks for your question.
There could be two reasons for your observation that spring to mind.
One is that after you have entered a few items into a column, it may be that there are two words that share the (for example) four same letters at the beginning, so Excel won't bring the rest of the word up for your straight away as it has yet to figure out which word you want to put in.
The other option is that the AutoComplete feature has been turned off. You can check this by going to Tools - Options - Edit and seeing if 'Enable AutoComplete for cell values' is checked.
Amanda
|