Sort by Date

  • Thread starter Thread starter scottnoddin77
  • Start date Start 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
 
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.
 
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

Back
Top