Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I've been trying to sort rows of data in Excel2003 that includes 3 colmns. I
want to sort the rows by the data in the first column. I click on a cell in the first column and then click sort in ascending order. The bottom row is moved to the top of the list, but the rest of the rows remain unsorted. I've tried highlighting the entire list, making the format of the first column all text, all numbers...nothing changes it. I can successfully sort another worksheet, but this one just won't sort. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You said you'd highlighted the whole list - did that include all 3 columns?
"juju" wrote: I've been trying to sort rows of data in Excel2003 that includes 3 colmns. I want to sort the rows by the data in the first column. I click on a cell in the first column and then click sort in ascending order. The bottom row is moved to the top of the list, but the rest of the rows remain unsorted. I've tried highlighting the entire list, making the format of the first column all text, all numbers...nothing changes it. I can successfully sort another worksheet, but this one just won't sort. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2003 can't do case sensitive sorting! | Excel Discussion (Misc queries) | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |