Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 17th 04, 09:53 PM
M.G
 
Posts: n/a
Default 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   Report Post  
Old December 17th 04, 10:04 PM
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Old December 17th 04, 11:17 PM
tjtjjtjt
 
Posts: n/a
Default

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   Report Post  
Old December 17th 04, 11:39 PM
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
repeated transpose from rows to columns with unequal groups kraymond Excel Discussion (Misc queries) 3 December 20th 04 02:39 PM
Unhide rows [email protected] Excel Discussion (Misc queries) 3 December 14th 04 05:28 PM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 05:40 PM
Select all data, multiple rows George Wilson Excel Discussion (Misc queries) 6 December 5th 04 08:16 PM
Making Rows into Columns Tony Williams Excel Discussion (Misc queries) 1 December 2nd 04 03:47 PM


All times are GMT +1. The time now is 03:42 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017