Sorting in Excel - Office Pro 2003

L

lovetoflyfish

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.
 
M

Marcelo

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:
 
L

lovetoflyfish

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
 
P

Pete_UK

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
 
L

lovetoflyfish

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top