Thread: Cell Groupings
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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