Do you have more than one sheet selected? You cannot sort grouped sheets.

Do you see [Group] in the title bar?

If so, select a sheet to ungroup them.

If they were grouped, make note that what was done to one sheet was done to
all in the group.


Gord Dibben Excel MVP



On Tue, 15 Mar 2005 14:09:05 -0800, "
wrote:



"marygries" wrote:

I have worksheets set up in Excel. I am wanting to sort 1 column of these
worksheets, but my sort button seems to be grayed out & I cannot select it.
How do I activate the sort function again. Any ideas?

When I go to tools, protection, unprotect is not there as an option???