98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training - Data entry
ms excel training - Data entry
Resolved · Low Priority · Version Standard
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
Project Introduction course
Project Intermediate 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
Thu 21 Jun 2007, 17:09Trainer Amanda said...
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
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. |
Excel tip:Reconciling a list to correspond with anotherMay have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way. |
