sorting problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My excel file has a header in row 1 from A1 to CV1, row one is bolded and
highlighted to distinguish it from the rest of the rows that holds contact
information.

My problem is that when I go to data sort and I select which column to sort
by it is only hightlighting about 6 columns, so now all the rest of my data
in the unselected columns do not match up with the correct person. I have
even tried selecting no header row and it still does it.

Can someone give me some insight on what I am doing wrong or a solution? I
am using Excel 2002
Thanks
sbrimley
 
Are you selecting all the data before doing your sort?

Quick way to do so - Ctrl-* (using the asterisk on the numeric keypad)
 

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

Similar Threads

Sorting day names chronologically 5
Automatic Sorting? 6
Sorting problem 2
Sorting data in one sheet 8
Filter & Sort 3
2 dimensional date sort 1
Sort defaults 1
Table Data Missing 4

Back
Top