Skip navigation

numbers format problem

473 Views 7 Replies Latest reply: Jan 27, 2013 1:33 AM by Yellowbox RSS
rrandrr Level 1 Level 1 (0 points)
Currently Being Moderated
Jan 25, 2013 11:04 PM

i select 1 cell slide right to select 3 cells. Moving over the second cell it selects a block of cells i don't want, how do i rectify this problem so as i only select the 3 cells i want?

numbers
  • Yellowbox Level 4 Level 4 (3,870 points)
    Currently Being Moderated
    Jan 25, 2013 11:35 PM (in response to rrandrr)

    Hi r,

     

    i select 1 cell

    How many clicks? 1 or 2?

     

    slide right to select 3 cells

    is the slide (drag) moving Cell 1?

     

    Are you dragging the white circle (Fill handle)? Don't!

     

    Try Shift Click.

     

    Click once in Cell 1.

    Screen Shot 2013-01-26 at 6.27.35 PM.png

     

    Move the cursor (don't drag) to Cell 3. Hold down the Shift key and click once in Cell 3

    Screen Shot 2013-01-26 at 6.30.58 PM.png

     

    All 3 cells now selected.

     

    I hope this helps for now.

     

    Ian

    MacBook Pro (13-inch, Mid 2012), OS X Mountain Lion (10.8.2)
  • Jerrold Green1 Level 7 Level 7 (28,125 points)
    Currently Being Moderated
    Jan 26, 2013 3:52 AM (in response to rrandrr)

    RR,

     

    Are you using a Mac or an iOS device?

     

    Jerry

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Jan 26, 2013 1:34 PM (in response to Jerrold Green1)

    "Slide" sounds like an iOS related action, and the issue sounds like what I've often referred to wrt striking multiple keys when I wanted only one, as "fat-finger syndrome."

     

    I suspect the OP isn't "sliding" in a purely horizontal direction, but has a slight up or down component causing the selection to include more than a single row. Happens to me when using a touchpad.

     

    Regards,

    Barry

  • Yellowbox Level 4 Level 4 (3,870 points)
    Currently Being Moderated
    Jan 26, 2013 4:47 PM (in response to rrandrr)

     

    26/01/2013 4:15 PM

     

     

    Thanks to previous replys but they don't seem to be solving my problem. probably because Im not describing my problem correctly.

    I dont want to remove the data in the cells mentioned..

    E.G I want to select G1,H1,I3 cells. When I try to select them, in anyway ive tried, as i select H1 it auto selects a block of cells B123 to I123 inclusive. I been playing whith this sheet for ages & think I may have formatted those cells in some way. I need to unformat that group so as i can select only the 3 I want. Any suggestion now that i've explained it that way?  Thanks in anticipation.

    I meant to mention I'm on Desktop Mac, OS X Version 10.7.5, Numbers '09 Version 2.3(554).

    numbers

     

    Hi again,

    I see what you mean.

    I'll have a think about it.

    Ian.

  • Yellowbox Level 4 Level 4 (3,870 points)
    Currently Being Moderated
    Jan 26, 2013 4:57 PM (in response to Yellowbox)

    rr,

     

    Hold down Command and Option keys then click on the cells you want to select.

     

    Ian.

     

    Screen Shot 2013-01-27 at 11.55.24 AM.png

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Jan 27, 2013 1:17 AM (in response to Yellowbox)

    Similar to Ian's suggestion, but not quite identical:

    Picture 12.png

    Click on any one of the three cells, then press and hold the command key as you click on the other two.

     

    The blue line around the selected cells is the selection rectangle. The yellow fill was applied to the selected cells after they were selected.

     

    I got different results using Ian's suggestion above. Here's a description of how the modifier keys affect a selection:

     

    command-click: Adds the clicked on cell to the selection it it was not selected; removes it from the selection if it was selected.

     

    shift-click: Expands or reduces the selection to the rectangular range defined by the cell initially selected at one corner and the clicked on cell at the opposite corner. All cells in the range are selected.

     

    option-click: Adding the option key to a click, or to any of the combinations above appears to have no effect.

    I though I had observed a different effect initially (Option-click, with or without command, seemed to select or deselect the table as an object, but I think that was caused by where I was clicking, rather than how.)

     

    Regards,

    Barry

  • Yellowbox Level 4 Level 4 (3,870 points)
    Currently Being Moderated
    Jan 27, 2013 1:33 AM (in response to Barry)

    Thanks Barry.

     

    I now realise that one of the cells must be selected before Command-Click can add other cells to the [all-over-the-place] selection. No need for my Command-Option-Click approach!

     

    Regards,

     

    Ian.

Actions

More Like This

  • Retrieving data ...

Bookmarked By (1)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.