Can excel sort entire rows of data like access?

J

Jack

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?
 
M

Myrna Larson

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.
 
Top