Changing cell order (alphabetizing)

[IdahoSkies]

I use to do this easily at another office I worked at but in my new office we use excel instead of the old program, which I can't remember (I think it comes with Wordperfect).

We use a spreadsheets to itemize our clients medical bills like:
1. Provider
2. Doctor
3. Date of Service
4. Amount Billed
5. Amount Paid by Insurance X
6. Amount adjusted by Insurance X
7. Amount Paid by Insurance Y
8. Amount adjusted by Insurance Y
9. Amount owed (SUM formula in this cell).

(For explanation sake items 1-9 we will call an "entry").

Once all the entry data is inputted I would like to be able rearrange the order of the entries by Doctor, or Provider or Date of Service, but I would like the rest of the entry to follow that portion of the entry and not get mixed up with the other entries (data integrity I think it is called). (I hope this makes sense). What I am wondering is how to I do that in Excel. I tried to build a database to replace the spreadsheets, but they would not do the Sum formula in 9.

Thanks for your help.

[JBeaucaire]

As long as your items 1-9 all exist in a single row, you're in business. People build databases in Excel all the time, the trick is to remember that one row represents a complete record.

So your list above would represent the "titles" in A1:J1. Then your data starts in row 2 with your first entry going across filling in the answers.

I know that means you'll have to scroll a little, or set the zoom to 60% or something, but this is how it's done.

===========
Once all your rows/entries are complete, you can use Excel's easy-to-use Data > Sort options to sort your database.

[IdahoSkies]

Awesome, thank you so much. I don't know why I did not see that before. Thank you for the quick response.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.