• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Keyboard Key while writing a formula in a table?

Prestonean

New Member
Hello! I did a quick google for this, but couldn't find an answer.


While working with a table, I create a new column at the right, and I start to type a vlookup formula. I know that excel knows the names of my columns, so I would like to type that in, rather than use the cell reference. I start the first letter or two, and then I see in the drop down "tool tip" sort of list, my column, and it's highlighted. I would like to use that - however, the only way I can determine selecting it, is to double-click it - which I'd rather not do, since I'm typing, I want to stay on the board, rather than go to the mouse... I've tried all sorts of keyboard clicks, but can't figure out the "select" function. Any ideas? Thanks!
 
Prestonean


Firstly, Welcome to the Chandoo.org Forums


Have you tried using Tab followed by the arrow keys
 
Ahh!! Thanks Hui! arrows keys to select what I want, and then tab - that works!


I am not technically new - but I didn't have an account in this area yet ;)


Thanks again!
 
Back
Top