How do you select two cells in different rows and columns with ou.

M

M.G

I was taking an assessment quiz and the question was "Move the cursor to cell
F5 without deselecting cell C2." This was to see how well I knew keyboard
shortcuts so I have to do this without using the mouse. I got the question
wrong, but I can't figure out the right answer.
 
T

tjtjjtjt

If the goal is to Select from C2 all the way to F5, then Frank's method is
the way to go. If you just need to select C2 and F5 but no other cells:

Press Shift+[F8]
Use the arrows keys to F5. Press F8. Then, press F8 again to deactivate the
Add mode.

tj
 
G

Gord Dibben

Which will select all intervening cells as well as C2 and F5, but is
technically correct if answer is to move to F5 without deselecting C2.

If you want just C2 and F5 selected..........

With C2 selected hit SHIFT + F8 to enter "ADD" mode.

Now use the arrow keys to move to F5.

Only C2 and F5 will be selected.

Gord Dibben Excel MVP
 
Top