If you use Excel frequently in your work, you may have already found this feature. So when we enter the character “D” or “d” into the cell, the existing phrase will automatically appear.Īnd this is the feature of autocomplete. Both phrases start with the same character “D” or “d”. And now we will input the phrase “DataNumen Access Repair” into cell A2. In this image, you can see that we have already input the phrase “DataNumen Excel Repair” into cell A1. Whenever you input the first character of an existing string, Excel will complete the remaining for you automatically. In such a case, AutoComplete feature in Excel will save your time. In Excel, sometimes you need to enter duplicate contents into a column repeatedly. And in this article, we will dig out the reason. In Excel, you will find that sometimes the autocomplete of cell values will not work.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |