Sort by Date

S

scottnoddin77

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
 
D

Dave O

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

Dave Peterson

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!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto-sort worksheet by date in column A 3
Recognising dates pre-1900 14
arranging dates in chronological order 3
Excel Date Setting 1
Sort using formula 15
Pivot Table 2
Help with formula 18
sort date 2

Top