How do I change how cells are sorted in an excel file?

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

Guest

I am working on an Excel file in which I have several columns. I need to sort
the information alphabetically by the middle column, however, I also need the
information in the first columns to stay with the information in the middle
columns.

For example my columns are like this:

Mr/Ms First Name Last Name Company
Address ETC...

I need to sort by Company but I need the other information to stay with the
respected company. Is this making any sense? Can someone help?
 
Tizzy,

Select all the columns prior to doing the sort. The information in the other columns will move
based on the column selected as the sorting key.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

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

how do I sort several columns in excel 1
Sorting day names chronologically 5
Sorting Alphabetically 3
Counting words in column 4
sumproduct and sorting 4
Sorting data in one sheet 8
Mailing address block: sorting 1 row to columns 1
Cells are not sorting correctly 2

Back
Top