How do I activate sort in Excel?

M

marygries

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?
 
M

marygries

marygries said:
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?
Click to expand...

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

Gord Dibben

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
 
Top