Numbers annoyingly treats two columns as one.

Discussion in 'Mac Apps and Mac App Store' started by ss957916, Oct 26, 2009.

  1. ss957916 macrumors 6502a

    Joined:
    Jun 17, 2009
    #1
    I have a table where, for some reason, if I select column F, it also selects column G, if I select G it also selects F. It means I can't move one without moving the other!

    Any ideas why it's doing this and how I can stop it?

    Thanks.
     
  2. Mal macrumors 603

    Mal

    Joined:
    Jan 6, 2002
    Location:
    Orlando
    #2
    You likely have some cells merged across the two. If you try to select the entire column, it has to also select that cell, and to be consistent, it then has to select the rest of the cells that line up with it (i.e. column G). Scan visually down the columns and look for a cell that spans both. You can either delete the row containing that cell, or split it into columns (don't recall which menu, though you can right-click and do it from there).

    jW
     
  3. JAT macrumors 603

    Joined:
    Dec 31, 2001
    Location:
    Mpls, MN
    #3
    Merging columns is a good way to get on a personal hit list. Please don't merge columns. On any spreadsheet software. Freaking marketing idiots.
     
  4. Consultant macrumors G5

    Consultant

    Joined:
    Jun 27, 2007
    #4
    Find merged columns, cut paste somewhere else.
    Do your thing and cut paste back. Takes 3 seconds.
     

Share This Page