Sorting data by Date

[Mark F.]

I have a sheet in with several columns. In each of the columns are two
text cells and a data/time cell. I want to know how to sort the sheet so
that the columns appear sorted by date with the earliest to latest. The
columns are laid out like this:

C D E F etc...
1 String String String String
2 Date Date Date Date
3 String String String String

Thanks.
Mark

 

[Jezebel]

Select the columns. Click Data > Sort. On the Sort dialog click Options and
select 'Left to right'. Then select Row 2 to sort by.