On the spreadsheet below with Data | Filter | Autofilter selected (for the header row - Date, Booking Start... etc.), when I choose either Sort Ascending or Sort Descending from the drop down list there is no sorting action performed on the rows (records). They remain in the (dis) ordered state prior to my selecting either Sort Ascending or Sort Descending.
If I highlight the range that I wish to sort and choose Data | Sort it works but not unless the range is highlighted
When I select one of the entries (i.e. 1-Aug, 2-Aug, 9-Aug, 10-Aug, 22-Aug, 24-Aug) all rows that match the date chosen are selected (including the contiguous data in the adjacent columns and the others are hidden (as I would expect).
Is there a setting I have missed?
Thanks in advance
If I highlight the range that I wish to sort and choose Data | Sort it works but not unless the range is highlighted
When I select one of the entries (i.e. 1-Aug, 2-Aug, 9-Aug, 10-Aug, 22-Aug, 24-Aug) all rows that match the date chosen are selected (including the contiguous data in the adjacent columns and the others are hidden (as I would expect).
Is there a setting I have missed?
Thanks in advance
fields.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
9 | Date | BookingStart | BookedFinish | Field | ActualFinish | BookedHours | FieldUsed? Y/N | UsedHours | ||
10 | 9-Aug | 8:00AM | 11:00AM | Dover1 | 11:00AM | 3:00 | y | 3:00 | ||
11 | 10-Aug | 9:00AM | 12:00PM | Dover2 | 12:00PM | 3:00 | y | 3:00 | ||
12 | 2-Aug | 11:00AM | 12:30PM | Dover5 | 12:30PM | 1:30 | y | 1:30 | ||
13 | 24-Aug | 7:30PM | 8:00PM | Dover2 | 8:30PM | 0:30 | y | 0:30 | ||
14 | 10-Aug | 7:30AM | 10:00AM | Dover5 | 10:00AM | 2:30 | n | |||
15 | 10-Aug | 11:30AM | 12:00PM | Dover4 | 12:00PM | 0:30 | y | 0:30 | ||
16 | 22-Aug | 3:30PM | 4:30PM | Dover1 | 4:30PM | 1:00 | n | |||
17 | 2-Aug | 11:30AM | 12:30PM | Dover2 | 12:30PM | 1:00 | y | 1:00 | ||
18 | 1-Aug | 8:30AM | 9:30AM | Dover4 | 10:00AM | 1:00 | y | 1:00 | ||
19 | 22-Aug | 7:00PM | 9:00PM | Dover4 | 9:00PM | 2:00 | y | 2:00 | ||
April |