When you are entering rows of data in a workbook, Excel has a handy feature that saves you keystrokes. If you enter sufficient characters to uniquely match an existing entry in the column, Excel automatically enters the remaining characters for you. All you need to do is press Tab to move on to the next cell.<\/p>\n
But what do you do if you don\u2019t want Excel to fill in the remaining characters. Let\u2019s say you are entering names in a column and you have already entered Christine. In a row below, you enter Chris. As soon as you do, Excel completes the entry as Christine.<\/p>\n
So what do you do? I\u2019ve seen people press Enter then go back and delete the unwanted characters. Quicker is to press Delete to remove the characters Excel entered then Tab to move on to the next cell.<\/p>\n","protected":false},"excerpt":{"rendered":"
When you are entering rows of data in a workbook, Excel has a handy feature that saves you keystrokes. If you enter sufficient characters to uniquely match an existing entry …<\/p>\n","protected":false},"author":4,"featured_media":28,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-332","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"\n