Select part of a text that exists already in an above cell
Posted
by pragadheesh
on Super User
See other posts from Super User
or by pragadheesh
Published on 2010-03-29T07:00:20Z
Indexed on
2010/03/29
12:03 UTC
Read the original article
Hit count: 305
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?
© Super User or respective owner