I have been having problems sorting data recently. Highlighting one column and sorting was only sorting that column and not all the other ones. It seems the problem occurs when one of the comuns is blank. Putting a dummy cell entry, such as zz, into each empty column seems to solve the problem. Something Microsoft need to fix for their next version of Excel.
Bookmarks