Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I try to sort in Excel only part of the table sorts
I have a spread sheet with 10 columns when I try to sort on date - the second
column only the first four columns sort. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I try to sort in Excel only part of the table sorts
You mean only the first 4 rows in the 2nd column? Please see: Data Isn't
Recognized he http://www.officearticles.com/excel/...soft_excel.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com "jrw562" wrote in message ... I have a spread sheet with 10 columns when I try to sort on date - the second column only the first four columns sort. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I try to sort in Excel only part of the table sorts
If you select the complete range yourself, then do data|sort, it'll work ok.
jrw562 wrote: I have a spread sheet with 10 columns when I try to sort on date - the second column only the first four columns sort. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I try to sort in Excel only part of the table sorts
No - I have some kind of range set up and all of the first four columns sort
correctly but nothing in the other 6 columns changes. "Anne Troy" wrote: You mean only the first 4 rows in the 2nd column? Please see: Data Isn't Recognized he http://www.officearticles.com/excel/...soft_excel.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com "jrw562" wrote in message ... I have a spread sheet with 10 columns when I try to sort on date - the second column only the first four columns sort. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I try to sort in Excel only part of the table sorts
That works if I am sorting date and the dates are the first column. But if
the date is the second column when I select range (ten columns) and go back to click on date column to sort on I loose the range selection. "Dave Peterson" wrote: If you select the complete range yourself, then do data|sort, it'll work ok. jrw562 wrote: I have a spread sheet with 10 columns when I try to sort on date - the second column only the first four columns sort. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I try to sort in Excel only part of the table sorts
Select your range, then use Data|Sort from the menu bar.
I do my best not to use those a-z and z-a icons. I think they cause more trouble than they're worth. jrw562 wrote: That works if I am sorting date and the dates are the first column. But if the date is the second column when I select range (ten columns) and go back to click on date column to sort on I loose the range selection. "Dave Peterson" wrote: If you select the complete range yourself, then do data|sort, it'll work ok. jrw562 wrote: I have a spread sheet with 10 columns when I try to sort on date - the second column only the first four columns sort. -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I try to sort in Excel only part of the table sorts
That works - thanx
"Dave Peterson" wrote: Select your range, then use Data|Sort from the menu bar. I do my best not to use those a-z and z-a icons. I think they cause more trouble than they're worth. jrw562 wrote: That works if I am sorting date and the dates are the first column. But if the date is the second column when I select range (ten columns) and go back to click on date column to sort on I loose the range selection. "Dave Peterson" wrote: If you select the complete range yourself, then do data|sort, it'll work ok. jrw562 wrote: I have a spread sheet with 10 columns when I try to sort on date - the second column only the first four columns sort. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Can I copy a table from Word into one cell in Excel without losing data? (Office 97) | Excel Discussion (Misc queries) | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Pivot Table Memory Issue - Excel crashes | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |