Have you saved the workbook with the messed up rows?

If not, Undo should reverse the action of your sort.

Just make sure when sorting to pre-select all data columns before the sort.

Don't let Excel guess.

As far as filtering...........with no idea of your data layout it is hard to
visualize your needs.


Gord Dibben MS Excel MVP

On Mon, 4 Aug 2008 16:25:00 -0700, hebgengirl
wrote:

I have input all my recipes into excel and I want to be able to sort them by
category, ie. according to type of food, rating, ease of preparation, etc.
The whenI tried to sort by clicking on the category title, only that column
sorted and it messed up the data because the rows didn't match up. I'd like
to be able to click on a column heading, rating for example, and have all my
favorite recipes appear according to the rating. I am using Microsoft Excel
2003.