It means you have one or more sections of merged cells in the sort area.
When you get the error message click on "Show help" to get a couple of
suggestions.
Merged cells cause no end of problems with sorting, copying, pasting, filtering
and a host of other functions I can't remember off-hand.
My suggestion.....find the merged cells and un-merge them.
CTRL + a(twice in 2003) and Format>Cells>Alignment. Uncheck the "merge cells"
option.
Gord Dibben MS Excel MVP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.