Can excel sort entire rows of data like access?
 

I do not have microsoft access. One of the benefits of access is that entire
rows of data will sort when you want them to. Example: a birthday column
will sort with the associated name column when you opt to sort names
alphabetically. Can excel do this and if so how?

As long as your list doesn't have any embedded blank rows, and all columns
have a header in the top row, the rows will sort together. Just select any
cell in, say, the name column, and click the sort button on the toolbar.


On Tue, 13 Sep 2005 09:47:01 -0700, "Jack"
wrote:

I do not have microsoft access. One of the benefits of access is that entire
rows of data will sort when you want them to. Example: a birthday column
will sort with the associated name column when you opt to sort names
alphabetically. Can excel do this and if so how?