Software

Ask something
Question Locked

Data Sort in Excel

0 helpful
5 replies

by richard.gernold

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
As a casual Excel user I am frustrated when I can't sort data. I must be doing something that inactivates the toolbar command under data. "Sort" is is light grey (as well as most other commands on the "Data" dialog list)and can't be used. What am I doing???

5 replies

by nearfatalfall

All the Excel references you'll ever need.. you'll also learn some new tricks.. ;)

by rahouseholder

Is the data you want to sort selected? I have been in a hurry many times and didn't select before I went to sort....

by tony

Go to start run
type excel /admin

by erinaldo

Are you authoring these sheets, or were they created by someone else? Sometimes the fact that the sheet is protected can disable the sort function.

Check Tools -> Protection -> Unprotect sheet.

This discussion is closed to new replies.