A
AMRichards
I have a spreadsheet in Excel 2003 where I need to sort columns A to K in
'batches' of 20 rows. In column L the 20 cells next to each batch are merged
with some text in them at 90 degrees to label those 20 rows.
I had been doing this successfully for some time, but the other day I tried
to do it and every time I select the range of cells to sort, it automatically
selects the whole set of rows when I initiate the sort instead of just
columns A to K. This then means that it cannot perform the sort because the
cells in column L are merged!
I got round the problem by deleting column L (it would not let me 'unmerge'
the cells because the option was greyed out) and thought I would just
manually put it back once I'd done the sort. However now it won't let me
merge cells in a vertical line either (option is greyed out).
Has anyone else experienced similar problems? Or am I doing something
silly? I really can't understand this as these options were working
perfectly well originally.
Any suggestions would be much appreciated.
Thank you.
'batches' of 20 rows. In column L the 20 cells next to each batch are merged
with some text in them at 90 degrees to label those 20 rows.
I had been doing this successfully for some time, but the other day I tried
to do it and every time I select the range of cells to sort, it automatically
selects the whole set of rows when I initiate the sort instead of just
columns A to K. This then means that it cannot perform the sort because the
cells in column L are merged!
I got round the problem by deleting column L (it would not let me 'unmerge'
the cells because the option was greyed out) and thought I would just
manually put it back once I'd done the sort. However now it won't let me
merge cells in a vertical line either (option is greyed out).
Has anyone else experienced similar problems? Or am I doing something
silly? I really can't understand this as these options were working
perfectly well originally.
Any suggestions would be much appreciated.
Thank you.