View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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.