Excel question - sorting columns?

Question

I'd like to rearrange my first column in alphabetical order. Unfortunately, there's associated information for each row in columns B, C, D, etc. When I rearrange it, all of the information doesn't match up anymore. How can I sort column A, and also rearrange the other columns so all information matches up correctly?

Answer 1

its easy dont just highlight a coulumn, HIGHLIGHT ALL of the columns. then click "data" menu and select sort.. then its up to you what column youll like to sort...

Answer 2

Do not select the entire column A, simply select any cell in column A, then click the sort button. This should automatically keep all the data in all the columns together.



This might cause problems with a header row, so it would probably be better to select your entire database and click data, sort. Use the dialog box to sort by column A ascending, and check the box if you have a header row.

Answer 3

First, I hope you have column headers. It makes life easier.



- If you select a column to sort, that column only sorts - the rest of the data stays in place.

- To sort the whole file, click the "table select" button (to the left of A, and above No. 1). This will select the whole file.

- click Data

cl Sort

- at the bottom left, click "my list has a header row"

- at the top, cl the down arrow to choose the header (column) on which you want to sort.

Answer 4

Highlight all of your columns, then hit Data - Sort. In the first box hit Column A then OK. All of your data will then match up.

Answer 5

Select all the columns you want to sort. Then click on the sort button on the toolbar (the button with the A Z and the arrow pointing downwards).



This should sort all the information in the selected columns in ascending order.

Answer 6

when you select SORT you should get a prompt to expand selection . make sure that it's selected. Expand selection keeps related column information together when Excel processes the sort.

Answer 7

you need to highlight the column to sort then do data sort

Answer 8

when you hit 'sort' you should receive a warning that there is data next to the data you want to sort. Hit 'expand the selection' and the data will follow the sort.

Answer 9

challenging stuff. look using yahoo and bing. that could actually help!