Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2006

Tip: Looking for answers? Try searching our database.

Sorting in Excel - Office Pro 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
lovetoflyfish - 03 Oct 2006 22:06 GMT
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.
Marcelo - 03 Oct 2006 22:23 GMT
hi,

make sure that all column have a "title", select all range ans Data | Sort

hth
Signature

regards from Brazil
Thanks in advance for your feedback.
Marcelo

> 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.
lovetoflyfish - 03 Oct 2006 22:49 GMT
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

> hi,
>
[quoted text clipped - 6 lines]
> > please?
> > Thank you and best regards.
Pete_UK - 03 Oct 2006 23:00 GMT
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

> Marcelo,
>
[quoted text clipped - 18 lines]
> > > please?
> > > Thank you and best regards.
lovetoflyfish - 03 Oct 2006 23:39 GMT
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

> 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.
[quoted text clipped - 25 lines]
> > > > please?
> > > > Thank you and best regards.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.