If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting data in one sheet
I created a sheet with many columns and rows. I want to be able to sort the
data in different columns but keep all of the row information together. For instance when I sort one of my rows alphabetically, the rest of the information in the other columns that pertains to it doesn't follow. |
#2
|
|||
|
|||
Sorting data in one sheet
when you do your sort, are you highlighting the entire table of data?
everything within your highlighted data should sort along with yoru selected field. "Gwen" wrote: I created a sheet with many columns and rows. I want to be able to sort the data in different columns but keep all of the row information together. For instance when I sort one of my rows alphabetically, the rest of the information in the other columns that pertains to it doesn't follow. |
#3
|
|||
|
|||
Sorting data in one sheet
I think part of the problem might be that I have the information in the first
column frozen so that when you're scrolling to the right you can still see the info in the first column. Do I have to highlight the whole table every time I want to sort? "Sean Timmons" wrote: when you do your sort, are you highlighting the entire table of data? everything within your highlighted data should sort along with yoru selected field. "Gwen" wrote: I created a sheet with many columns and rows. I want to be able to sort the data in different columns but keep all of the row information together. For instance when I sort one of my rows alphabetically, the rest of the information in the other columns that pertains to it doesn't follow. |
#4
|
|||
|
|||
Sorting data in one sheet
It's typically only an issue when you have blank columns in the middle of
your table. If you put anything in the header row for all columns, it should automatically highlight the entire table. The frozen pane should not cause an issue with sorting... "Gwen" wrote: I think part of the problem might be that I have the information in the first column frozen so that when you're scrolling to the right you can still see the info in the first column. Do I have to highlight the whole table every time I want to sort? "Sean Timmons" wrote: when you do your sort, are you highlighting the entire table of data? everything within your highlighted data should sort along with yoru selected field. "Gwen" wrote: I created a sheet with many columns and rows. I want to be able to sort the data in different columns but keep all of the row information together. For instance when I sort one of my rows alphabetically, the rest of the information in the other columns that pertains to it doesn't follow. |
#5
|
|||
|
|||
Sorting data in one sheet
Do not let Excel guess at the range to be sorted.
Always pre-select the entire range you want to stay together. Gord Dibben MS Excel MVP On Wed, 20 May 2009 08:18:01 -0700, Gwen wrote: I think part of the problem might be that I have the information in the first column frozen so that when you're scrolling to the right you can still see the info in the first column. Do I have to highlight the whole table every time I want to sort? "Sean Timmons" wrote: when you do your sort, are you highlighting the entire table of data? everything within your highlighted data should sort along with yoru selected field. "Gwen" wrote: I created a sheet with many columns and rows. I want to be able to sort the data in different columns but keep all of the row information together. For instance when I sort one of my rows alphabetically, the rest of the information in the other columns that pertains to it doesn't follow. |
Thread Tools | |
Display Modes | |
|
|