Normally you select any one cell, and select the sort you want and this is done for all data -keeping the rows in the correct sequence. If you try to select all the data it does not work, and tells you to select a cell
I have used Excel 2003 and at this time am using Excel 2007 and the sort function works perfectly by selecting ALL data and then selecting by column and sort on cell values. Have you tried creating another small spreadsheet and try sort on that as it occurs to me that there might be a problem with the spreadsheet that you are working on?
As Terry Brown said In Outlook 2010 only select one cell and click on sort the other columns will follow the selected cell. The sort will be upset if you select a column. Then only the selected column will be sorted.
HenryF75 That doesn't sound right, because if you have only selected one column you will not get the options for the other columns/fields in a custom sort. I get a popup telling me there is other data in adjoining cells and warning me they will not be sorted. (but that is in Excel 2003)
I have Office 2010 and have not to date experienced this problem, except where I have accidentally selected one or more columns before using the sort - but as lotvic points out, even then I do get a warning.
To be safe, best select the small box in the top left hand corner of the worksheet (which selects the entire worksheet) or click Ctrl+A )same thing) BEFORE opening the Sort function