Marjolein has attended:
Excel Introduction course
Upgrade to Office 2007 course
Excel Intermediate course
Sort data with different size cells
Dear Sir,
I have made a big data base with columns that are named after - Store - City- Country etc.
I would like to sort the data according to the country and normally that works but now, because some of the cells in column A have been merged - it does not seem to work.
Could you help me with this?
Thank you. Kind regards
RE: Sort data with different size cells
Hi Marjolein
Thank you for your question.
A sort will not work on a column that contains any merged cells, so the merged cells will need to be unmerged (which you can do by clicking the merge button on the formatting toolbar) then enter the relevant data into each of the cells.
Amanda