Selecting multiple cells

sciguylvms · Mar 24th, 2002, 08:07 AM

Dragging to select multiple cells always causes me a problem if I have to select cells that are not on the screen. When my cursor hits the bottom of the screen the selecting process takes off and I can't stop the scrolling until it gets to around row 800+.

Is there some key I can push that would slow down the scrolling or stop the scrolling while I'm dragging/selecting?

Thanks, Sciguy

Dave Hawley · Mar 24th, 2002, 08:16 AM

Hi Sciguy

Unfortunately the easiest thing might be to look in the Excel help for "shortcut keys".

Wheel mouse can also help, once you get the hang of them..or so they tell me

Afcb · Mar 24th, 2002, 08:25 AM

Copy the cell.
Go to Edit>GoTo and type the range you want to fill in the Reference box.
Paste

Or if you merely want to select a range, go to Edit>GoTo and type the range in the Reference box.

[ This Message was edited by: Afcb on 2002-03-24 07:26 ]

[ This Message was edited by: Afcb on 2002-03-24 07:30 ]

Mood · Mar 24th, 2002, 08:45 AM

Another way of selecting multiple cells is to use the shift/end/arrow key combinations. Select the first cell, hold down the shift key, press the end key, and then press any of the arrow keys, repeat end and arrow key multiple times if you have to. The only drawback is the selection process stops when it encounters an empty cell, you will have to repeat the end/arrow keys to select more cells (while still holding the shift key down.)
HTH
Peter

Jay Petrulis · Mar 24th, 2002, 09:00 AM

Quote:

On 2002-03-24 07:25, Afcb wrote:
Copy the cell.
Go to Edit>GoTo and type the range you want to fill in the Reference box.
Paste

Or if you merely want to select a range, go to Edit>GoTo and type the range in the Reference box.

[ This Message was edited by: Afcb on 2002-03-24 07:26 ]

[ This Message was edited by: Afcb on 2002-03-24 07:30 ]

Hi,

A similar idea, only less keystrokes/mouseclicks:

Use the Name Box and type in your range to select (e.g. A1:B630). Equivalent to using the Edit>GoTo feature.

Both of these are nice options.

Also, if this is a range that is commonly selected, naming it may help, too.

Bye,
Jay

Yogi Anand · Mar 24th, 2002, 09:02 AM

Hi sciguylvms:
To keep control of what you are selecting, hilite the first row of your selection, then while holding the SHIFT KEY, navigate with UP, DOWN, LEFT, RIGHT keys till you reach the destination cell ... this way you wouldn't have things flying all over the place!

RET79 · Mar 24th, 2002, 09:21 AM

If selecting a large number of rows, say 800 or so, I tend to find that pressing shift and page down seems to work better than just dragging the mouse arrow down. But, if you have no empty cells then the method of using shift and end is best.

Alternatively, if you are confident writing VBA code, perhaps you would like to type Range{"A1:A560") etc. from the immediate window in the VB editor, which would be a minimised window of course so that you can see both the excel spreadsheet and the immediate window at the same time.

Hope this helps

RET79

sciguylvms · Mar 24th, 2002, 09:35 AM

Thanks everyone for your input.
All ideas were very helpful. Yogi, your advice was most helpful and gave me the most control...thanks

Sciguy

[ This Message was edited by: sciguylvms on 2002-03-24 08:37 ]

Mar 24th, 2002, 09:02 AM	#6
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi sciguylvms: To keep control of what you are selecting, hilite the first row of your selection, then while holding the SHIFT KEY, navigate with UP, DOWN, LEFT, RIGHT keys till you reach the destination cell ... this way you wouldn't have things flying all over the place! __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 24th, 2002, 08:07 AM	#1
sciguylvms New Member Join Date: Mar 2002 Posts: 2	Dragging to select multiple cells always causes me a problem if I have to select cells that are not on the screen. When my cursor hits the bottom of the screen the selecting process takes off and I can't stop the scrolling until it gets to around row 800+. Is there some key I can push that would slow down the scrolling or stop the scrolling while I'm dragging/selecting? Thanks, Sciguy

Mar 24th, 2002, 08:16 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Sciguy Unfortunately the easiest thing might be to look in the Excel help for "shortcut keys". Wheel mouse can also help, once you get the hang of them..or so they tell me

Mar 24th, 2002, 08:25 AM	#3
Afcb New Member Join Date: Mar 2002 Posts: 5	Copy the cell. Go to Edit>GoTo and type the range you want to fill in the Reference box. Paste Or if you merely want to select a range, go to Edit>GoTo and type the range in the Reference box. [ This Message was edited by: Afcb on 2002-03-24 07:26 ] [ This Message was edited by: Afcb on 2002-03-24 07:30 ]

Mar 24th, 2002, 08:45 AM	#4
Mood New Member Join Date: Mar 2002 Location: Manitoba, Canada Posts: 22	Another way of selecting multiple cells is to use the shift/end/arrow key combinations. Select the first cell, hold down the shift key, press the end key, and then press any of the arrow keys, repeat end and arrow key multiple times if you have to. The only drawback is the selection process stops when it encounters an empty cell, you will have to repeat the end/arrow keys to select more cells (while still holding the shift key down.) HTH Peter

Mar 24th, 2002, 09:21 AM	#7
RET79 Board Regular Join Date: Mar 2002 Location: England, UK. Posts: 526	If selecting a large number of rows, say 800 or so, I tend to find that pressing shift and page down seems to work better than just dragging the mouse arrow down. But, if you have no empty cells then the method of using shift and end is best. Alternatively, if you are confident writing VBA code, perhaps you would like to type Range{"A1:A560") etc. from the immediate window in the VB editor, which would be a minimised window of course so that you can see both the excel spreadsheet and the immediate window at the same time. Hope this helps RET79

Mar 24th, 2002, 09:35 AM	#8
sciguylvms New Member Join Date: Mar 2002 Posts: 2	Thanks everyone for your input. All ideas were very helpful. Yogi, your advice was most helpful and gave me the most control...thanks Sciguy [ This Message was edited by: sciguylvms on 2002-03-24 08:37 ]