Is it possible to arrow to a different cell while in edit mode?

G

Guest

Is it possible, after having hit F2 in a cell with a formula, to move the
cursor to a new cell and the formula "auto" reference the new cell? i.e. I'd
like to change the reference in the formula from B11 to C25 by highlighting
B11 in the formula then physically selecting C25. (the way cell referencing
works when starting a formula)

I think I've tried all combinations of Alt+arrow, Ctrl+arrow,
Alt+Shift+arrow, Alt+Ctrl+Cross fingers+Squint, etc...
 
P

Peo Sjoblom

One way to change cell ref witing a formula in edit mode, high light the
cell reference holding down shift and pressing arrow key, then press F5 and
type in the the cell you want, then press enter twice
Can't see it saving any time though
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can a text box use a formula or cell reference 3
Chrome keyboard shortcuts 2
Cell ref is it possibile to calculate / change this in a formula 3
in excel - arrow keys won't work & cursor will not select a cell 4
moving the cursor in a macro 1
Displaying arrow in a dropdown list within cell 2
Excel: Arrow keys scroll instead of moving to next cell??!! 2
Need macro to move to first blank cell in column 6

Top