PDA

View Full Version : My questions about custom sort window



abbasi
2014-05-29, 03:38 PM
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?

Bob Phillips
2014-05-29, 05:18 PM
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?

Are you trying to sort tables?


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?

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


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

Sorting by rows rather than by columns.

abbasi
2014-05-31, 09:14 AM
Yes, it's table.

Bob Phillips
2014-05-31, 07:53 PM
It always seems to be grayed out on tables, tables always have headers.

abbasi
2014-06-02, 01:49 PM
Thank you very much.