| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting in Excel - Office Pro 2003
I can sort one column but the other column(s)' information does not follow
its corresponding info from the sorted column - how do I make this work, please? Thank you and best regards. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sorting in Excel - Office Pro 2003
hi,
make sure that all column have a "title", select all range ans Data | Sort hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "lovetoflyfish" escreveu: I can sort one column but the other column(s)' information does not follow its corresponding info from the sorted column - how do I make this work, please? Thank you and best regards. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sorting in Excel - Office Pro 2003
Marcelo,
Thank you for your kind and timely reply. I figured out how to select all - I highlighted all by clicking on the top left cell (above 1 and to the left of A) and then chose Data, Sort, and then chose the column letter that I wished to sort. It seems so simple now. Best regards, lovetoflyfish "Marcelo" wrote: hi, make sure that all column have a "title", select all range ans Data | Sort hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "lovetoflyfish" escreveu: I can sort one column but the other column(s)' information does not follow its corresponding info from the sorted column - how do I make this work, please? Thank you and best regards. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sorting in Excel - Office Pro 2003
As long as you do not have gaps in your data, you can click anywhere in
the data and CTRL-A will select the data before you sort. Hope this helps. Pete lovetoflyfish wrote: Marcelo, Thank you for your kind and timely reply. I figured out how to select all - I highlighted all by clicking on the top left cell (above 1 and to the left of A) and then chose Data, Sort, and then chose the column letter that I wished to sort. It seems so simple now. Best regards, lovetoflyfish "Marcelo" wrote: hi, make sure that all column have a "title", select all range ans Data | Sort hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "lovetoflyfish" escreveu: I can sort one column but the other column(s)' information does not follow its corresponding info from the sorted column - how do I make this work, please? Thank you and best regards. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sorting in Excel - Office Pro 2003
Thank you as well, Pete_UK,
I have never been one to use keyboard shortcuts - have no good answer for that one. It has been nice to see and receive help so quickly - I'm not used to that in my own home! Best regards to all, lovetoflyfish Prospect (Louisville), KY, USA "Pete_UK" wrote: As long as you do not have gaps in your data, you can click anywhere in the data and CTRL-A will select the data before you sort. Hope this helps. Pete lovetoflyfish wrote: Marcelo, Thank you for your kind and timely reply. I figured out how to select all - I highlighted all by clicking on the top left cell (above 1 and to the left of A) and then chose Data, Sort, and then chose the column letter that I wished to sort. It seems so simple now. Best regards, lovetoflyfish "Marcelo" wrote: hi, make sure that all column have a "title", select all range ans Data | Sort hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "lovetoflyfish" escreveu: I can sort one column but the other column(s)' information does not follow its corresponding info from the sorted column - how do I make this work, please? Thank you and best regards. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I install Excel Solver without the Office 2003 disk? | Excel Worksheet Functions | |||
| how do i convert . xlsx file to office 2003 (excel) | Excel Discussion (Misc queries) | |||
| In office 2003 how can FIXEDSYS font avail in EXCEL & not in WORD | Excel Discussion (Misc queries) | |||
| I am running Excel 2003 from Office 2003 Professional | Excel Discussion (Misc queries) | |||
| Want to buy just EXCEL 2003 not the entire microsoft office suite | Excel Discussion (Misc queries) | |||
Linear Mode
