.

Also question is, how do you sort by date in Excel without mixing data?

General Sort

1. Click into any cell in the COLUMN you want to sort by within your list. (DO NOT highlight that column as this will sort that column only and leave the rest of your data where it is.)
2. Click on the DATA tab.
3. Click on either the Sort Ascending or Sort Descending. button.

Also Know, why is my Excel spreadsheet not sorting properly? Make sure no hidden rows or columns exist. If you're sorting by a column containing a formula, Excel will recalculate the column after the sort. If the values change after the recalculation, such as with RAND, it may appear that the sort did not work properly, but it did.

how do I sort by date in Excel 2010?

To sort by date or time:

1. Select a cell in the column you want to sort by. Selecting a column to sort.
2. From the Data tab, click the ascending command to Sort Oldest to Newest or the descending command. to Sort Newest to Oldest.
3. The data in the spreadsheet will be organized by date or time.

How do I sort excel and keep rows together?

Then click the Sort button in the Data tab. Use the drop-downs to select the column or columns to sort by and check the box "My data has headers" if that applies. Use the Order drop-down menu to choose which order to sort the data in, whether largest to smallest or smallest to largest. Click OK when you are done.