How do I activate sort in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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???
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I activate sort in Excel? 2
Default column in Excel sort - Office 2007 7
Cell reference value to remain constant in a sort using Paste Link 2
Sorting in multiple worksheets 1
Excel sort macro 5
Enabling Autofilter and Sorting in a Protected Sheet 2
'Cannot insert object' message when I try to put a button on a worksheet 7
security - protecting a worksheet 2

Back
Top