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? Thanks for any help!!
 
The only time I have ever seen the A-Z or Z-A buttons dimmed is when editing
cell content. Make sure the word 'Ready' appears at the left end of the
Status Bar, and not the word 'Enter' or 'Edit'.

If this doesn't help, please post back with more specific detail including
version.

LOL |:>)
 
Make sure the worksheet doesn't have protection turned on. The buttons will
be grayed out if the cells are locked and protection is enabled.
 
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? 3
Default column in Excel sort - Office 2007 7
Sorting in multiple worksheets 1
Enabling Autofilter and Sorting in a Protected Sheet 2
'Cannot insert object' message when I try to put a button on a worksheet 7
Cell reference value to remain constant in a sort using Paste Link 2
Excel sort macro 5
sorting numbers with hyphens in excel 1

Back
Top