Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you select two cells in different rows and columns with ou.
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. |
#2
|
|||
|
|||
Hi
hold down the SHIFT key -- Regards Frank Kabel Frankfurt, Germany M.G wrote: 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. |
#3
|
|||
|
|||
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 "M.G" wrote: 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. |
#4
|
|||
|
|||
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 On Fri, 17 Dec 2004 23:04:33 +0100, "Frank Kabel" wrote: Hi hold down the SHIFT key -- Regards Frank Kabel Frankfurt, Germany M.G wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
Unhide rows | Excel Discussion (Misc queries) | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
Select all data, multiple rows | Excel Discussion (Misc queries) | |||
Making Rows into Columns | Excel Discussion (Misc queries) |