I need to clarify my first question.......?

Question

On the Excel question about 10 minutes ago... I received 3 good answers from the limited information I submitted. Thanks to all.

I'll provide more details: I run a spreadsheet for school in a state prison. The spreadsheet has a list (columns) of inmates' names, prison numbers, cell #s, teachers, and am or pm. I type in and change about 50 a day. The first column are the names. If I highlight the names, they sort, but all the other data doesn't, which as you can imagine "ain't" right. I'm putting the cursor on the first blank field above the names - it works fine on some (I have 16 different speadsheets), but not on others. I've tried to find the solution - know it's probably some little thing that I'm doing, however......

I hope this clears it up. Sorry about the first crappy question. : )

Answer 1

Make sure to choose all of the data you want to sort. Select the column by clicking the top of the column and making sure it highlights the whole column. This tells Excel what data you want to sort. If it still doesn't sort, I can't tell you what's wrong. I've encountered this where some of the fields in the column next to the one being sorted are blank. It sorts just the selected column, not the rest. Its a problem in Excel, not the way you are doing it.

Honestly, I think you may want to lean how to use Access. It is a database that would keep better track of all of the information, and sorting is much easier. Access is a little harder to learn, you may want to take a class on it, but it will help you to keep better track of your information.

Answer 2

Highlight all columns of data. Click on the Data option, then sort. You should get a popup asking which columns to sort first and in what order.