Numbers annoyingly treats two columns as one.

[ss957916]

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.

 

[Mal]

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

 

[JAT]

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.

 

[Consultant]

Find merged columns, cut paste somewhere else.
Do your thing and cut paste back. Takes 3 seconds.