Selecting multiple cells
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Selecting multiple cells

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  4. #4
    New Member
    Join Date
    Mar 2002
    Location
    Manitoba, Canada
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  5. #5
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  6. #6
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  8. #8
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com