Prompted by a thread involving sorting by colour it set me wondering what stuff people would really like to see in Excel. I must admit colour sorting wouldn't have been high on my list of priorities.

Is there in fact a forum/route to notify wish list items for MS to pick up on?

The functionality that always annoys me is when selecting a range for advance filtering and then finishing with the copy to location on another sheet, getting the unhelpful message 'you can only copy filtered data to the active sheet'. It seems so counter intuitive.

Not only that but when you do start out on the 'Active' sheet label, the one to which you want the filtered data to appear, you get the even more annoying message that says you must select at least two rows, and then to add insult to injury when you do select more than two rows Excel becomes yet more annoying and tells me that it can't determine which rows contain the label and you have to jump back to the origin sheet.

Is there anything more annoying than this? Or have I been doing it wrong all these years

I'd like to see this fixed.

What deficiencies annoy others and what additional functionality would you like?

Regards