So here's my question -- hopefully someone can help me:

I have merged cells A1:A5 through D1:D5 (so its a 4x5 block at the top of my spreadsheet as a key). Starting at the 6th row I have the labels for my columns. I need to sort the data underneath the 6th row, but Excel tells me there is a formating issue. I do NOT want to sort rows 1-6; I only want to sort the data underneath it and leave the top legend as it is.

Can I tell Excel where to start sorting? Or is the default to ALWAYS sort at row 1?

Thanks!