Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Groupings
I am currently making an Excel spreadsheet of all of my baseball cards
(several thousand). After I put them in, I want to sort by name. I have information such as the Name, Team Name, Year, and Brand of card in different columns. I want to group all of the information together for each Row so all the information travels together when I sort by name. Does anyone know how to do this? EXAMPLE: Column A B C D Row 7: Sheets, Ben Milwaukee Brewers 2008 Topps Row 8: Marmol, Carlos Chicago Cubs 2008 Topps I want the Sheets, Ben, Milwaukee Brewers 2008 and Topps to all group together when I sort. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Groupings
Just select all the columns when you do the sort. So if you sort by name or
by team, all the data on the row will move with the column being sorted. -- Gary''s Student - gsnu200829 "J. Glynn" wrote: I am currently making an Excel spreadsheet of all of my baseball cards (several thousand). After I put them in, I want to sort by name. I have information such as the Name, Team Name, Year, and Brand of card in different columns. I want to group all of the information together for each Row so all the information travels together when I sort by name. Does anyone know how to do this? EXAMPLE: Column A B C D Row 7: Sheets, Ben Milwaukee Brewers 2008 Topps Row 8: Marmol, Carlos Chicago Cubs 2008 Topps I want the Sheets, Ben, Milwaukee Brewers 2008 and Topps to all group together when I sort. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Groupings
To keep all the columns of each row together, you need to select all the columns (or at least all the columns you want to keep together). Then, open the Sort dialog (from the Data menu) and select the column(s) that will be used as the keys for the sort. For example, if your data is in columns A to K and you want to sort by the values in column C, select columns A to K, open the Sort dialog, and choose C as the first sort key. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Mon, 26 Jan 2009 22:55:00 -0800, J. Glynn <J. wrote: I am currently making an Excel spreadsheet of all of my baseball cards (several thousand). After I put them in, I want to sort by name. I have information such as the Name, Team Name, Year, and Brand of card in different columns. I want to group all of the information together for each Row so all the information travels together when I sort by name. Does anyone know how to do this? EXAMPLE: Column A B C D Row 7: Sheets, Ben Milwaukee Brewers 2008 Topps Row 8: Marmol, Carlos Chicago Cubs 2008 Topps I want the Sheets, Ben, Milwaukee Brewers 2008 and Topps to all group together when I sort. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Groupings in a scattergraph | Charts and Charting in Excel | |||
pivot table groupings | Excel Discussion (Misc queries) | |||
Excel should allow tab groupings. | Excel Discussion (Misc queries) | |||
Subtotals/Groupings | Excel Worksheet Functions | |||
Groupings within PivotTables | Excel Worksheet Functions |