Moving columns in Numbers - it's not letting me do it!

I seem to have this bizarre bug in Numbers, and it can't be normal behaviour. If I click on a column tab, it doesn't highlight the one column, it highlights the whole spreadsheet. Similarly, I can't select, say, cell D1 and drag the cursor down to D20 to select a column that way, because after highlighting so many cells, it will go and select the whole sheet.

I've searched the net for a solution and haven't found one, and the only thing I suspect is causing the problem is some merged cells. Problem is, I can't split the merged cells back into individuals, as after five or six attempts at doing it, it adds extra cells and messes up the spreadsheet (one I had to import as an Excel 2003 file since FAME doesn't do Numbers or CSV).

Any ideas? I'm stumped.

Macbook, Mac OS X (10.4.10)

Posted on Oct 30, 2007 2:52 PM

Reply
3 replies

Oct 31, 2007 5:31 AM in response to Ashka

Thanks for your help. I started doing what you suggested, before realising it was quicker to just delete the row and reinsert it (they were blank). That fixed things nicely, although I'll be sending feedback to Apple since I don't think that's expected behaviour (it certainly doesn't happen in Excel).

So, problem sorted. Thanks again =)

Oct 30, 2007 9:04 PM in response to ljmachin

You will need to un-merge the cells first.
1. If you have an uneven number merge select the merged cell plus the next one and merge,
2. Once you have an even number of columns merged. Select the columns and make them all the same size....... then use the split command in the inspector. The split command only splits in Half.
Same system for merged rows.
Best.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Moving columns in Numbers - it's not letting me do it!

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.