I want sort a list but the sort is unlit on the home tab how do I

  • Thread starter Thread starter chetrx
  • Start date Start date
C

chetrx

I have added items to my list and want to sort them again.The sort on the
home tab is not lit and when I click on it it the drop down menu dose not
come up and allow me to make a choice even if I have the column
selected.Something seem to have locked it.What should I do or look for thanx
(e-mail address removed)
 
chetrx said:
I have added items to my list and want to sort them again.The sort on the
home tab is not lit and when I click on it it the drop down menu dose not
come up and allow me to make a choice even if I have the column
selected.Something seem to have locked it.What should I do or look for thanx
(e-mail address removed)
Click to expand...
 
Sounds like maybe the sheet is protected. Go to Tools - Protections and see
if it says unprotect sheet.
 
I think you are correct but I CANT LOCATE the tools option you mentioned.It
is not on the bar anywhereI went to review under protection it is not checked
I looked in cell format not there either.I am still stuck.Thanks for trying I
may have to start all over again.I did a test.Its working on a new project.
(e-mail address removed)
chetrx
 

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 paste in sorted area? 4
Sorting Macro 4
Custom Sort 1
I want my formulas to update when I sort the data, but they dont? 1
I want to sort everything but my validation list 5
if able, how do you sort Tabs in excel (alpha-numeric) ?? 3
How to sort a drop-down list? 1
How do I sort the whole row at once in Excel? 2

Back
Top