How do you work the Sort Filter on an Excel Spreadsheet?

Question

When I turn it on, it only sorts the first row and none of the others. Used to use it all the time, but must be doing something wrong. Brain getting addled with age!!

Thanks all, got it working now - POET's day so no more worries.

Answer 1

Select top cell of the column you want to sort.
From menu, choose data, sort. Make sure the range (the column of data you want to sort) is highlighted. Click ok.
(Excel 2003) - what version you using?

Answer 2

Select your table you want to sort, then go to the Data menu and click Sort. You can then sort by up to 3 columns, ascending or descending.

Filters are slightly different. Again, select your table and from the Data menu select Filter then AutoFilter. Now all the columns have drop-down arrows for you to select specific data to display

Answer 3

Select the row or column you want to sort, sort according to what you want. Beware, Excell does not work like Access, so after sorting look at the rest of your sheet carefully before proceding any further.

Answer 4

Select all of the rows and columns you want to be sorted, then when you sort BY the first row, the other data will fall into place.

Answer 5

Select the cells you need sorted then go into the sort filter for advanced sorting features.

Answer 6

highlight all of the columns in your spreadsheet as in A through GG. then hit sort. select the column you wish to sort by. as in column R

Answer 7

Click on advanced filter.

Answer 8

click on start at bottom left screen