Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data in another sheet | Excel Worksheet Functions | |||
Sorting Data from a different sheet | Excel Worksheet Functions | |||
Sorting data from one sheet to another | Excel Discussion (Misc queries) | |||
sorting data from one sheet to another | Excel Worksheet Functions | |||
SORTING DATA TO ANOTHER SHEET | Excel Worksheet Functions |