My questions about custom sort window

Hi all,

I use M. Excel 2010 on my Win 7 machine.
In my table, when I use custom sort there are some odd thinks for me.

1- The "My data has headers" is always gray and when table has header it's checked otherwise no. But since it's gray I can't change it, why?
2- In the custom sort window there is a button named Options. When clicked it opens new small window. How does the case sensitive option work?
3- sort left to right in the small previous window is always gray. How can I use it and for what?

abbasi said:

1- The "My data has headers" is always gray and when table has header it's checked otherwise no. But since it's gray I can't change it, why?

Click to expand...

Are you trying to sort tables?

abbasi said:

2- In the custom sort window there is a button named Options. When clicked it opens new small window. How does the case sensitive option work?

Click to expand...

What it says on the tin, it sorts lower-case separately from upper-case.

abbasi said:

3- sort left to right in the small previous window is always gray. How can I use it and for what?

Click to expand...

Sorting by rows rather than by columns.

Yes, it's table.

It always seems to be grayed out on tables, tables always have headers.

Thank you very much.