Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link rows in Excel so they will stay together during sort? | Charts and Charting in Excel | |||
Excel as Data Entry into Access Database | Excel Discussion (Misc queries) | |||
Sort rows across multiple worksheets - Excel 2003 | Excel Worksheet Functions | |||
How do I import data into Excel that exceeds 70000 rows? | Excel Discussion (Misc queries) | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) |