Keystroke question

[erinayn]

I've attached a little screenshot in an attempt to describe the question.
When I'm entering data down a column Excel autofills data that starts with what I've started to type. Is there a keystroke to take me to the end of the data but keep the cell active so I can just start typing.

In the attached example, I'd like to type a P and have the language populate and hit some keystroke and be able to then type "- Customer Service".

Any ideas would be appreciated.

I think I used to be able to hit "End" or "F5" but can't find anything now.

[oeldere]

a1 = P
b1 = costumer service
c1 = a1&" "&b1

[quekbc]

Hi erinayn,

It's strange how your End key is no longer working. Mine still works. Perhaps you can try Ctrl + Right arrow? That works for me too.

[erinayn]

Got an answer

Looks like it waiting for confirmation that its a Used Cell before End works.

I just hit F2 and then End.

Thanks for the help!