Select part of a text that exists already in an above cell
- by pragadheesh
How do I get Excel to partially auto-complete a word using another that already exist in the same worksheet?
Let's say I have the word "Microsoft" in a cell and in the cell below I want to type the word "Microhard".
When I start typing Microhard, the word Microsoft appears shaded in black.
How can I select the "Micro" part alone from Microsoft and continue to fill out the rest with "hard" without it trying to fill out as Microsoft?