Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sort by Date
I was wondering how i sort dates in time order. I am making a bowling score average sheet and I have put the scores in, but not in chronological order. I have five colums across and was wondering if when i sort the dates will all the other information stay with the same date. Thanks -- scottnoddin77 ------------------------------------------------------------------------ scottnoddin77's Profile: http://www.excelforum.com/member.php...o&userid=26656 View this thread: http://www.excelforum.com/showthread...hreadid=399309 |
#2
|
|||
|
|||
The information will maintain its association with the date if you
highlight the entire row to indicate your search range. For instance, note that when you left-click the 2 that serves as row label, the entire row is highlighted. If you highlight all your data in that manner and perform the sort on the date column, the information associated with a given date will maintain its association. |
#3
|
|||
|
|||
Select your whole range (just one header row--but all the columns in that
range). Then do Data|sort. (I hate those A-Z and Z-A icons--too many things can go wrong!) scottnoddin77 wrote: I was wondering how i sort dates in time order. I am making a bowling score average sheet and I have put the scores in, but not in chronological order. I have five colums across and was wondering if when i sort the dates will all the other information stay with the same date. Thanks -- scottnoddin77 ------------------------------------------------------------------------ scottnoddin77's Profile: http://www.excelforum.com/member.php...o&userid=26656 View this thread: http://www.excelforum.com/showthread...hreadid=399309 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort worksheets in excel? i.e. Order them by date | Excel Worksheet Functions | |||
Can't sort by date | New Users to Excel | |||
Can't sort by date | New Users to Excel | |||
Can't sort by date | New Users to Excel | |||
Date sort problems | Excel Discussion (Misc queries) |