Want to sort a sheet by one column and have info in rows stay with column entry Thanks
C Curt Sep 28, 2006 #1 Want to sort a sheet by one column and have info in rows stay with column entry Thanks
G Gord Dibben Sep 28, 2006 #2 Curt Make sure you select all adjacent columns before sorting on your chosen column. Do not let Excel guess what should be included in the data range. Gord Dibben MS Excel MVP
Curt Make sure you select all adjacent columns before sorting on your chosen column. Do not let Excel guess what should be included in the data range. Gord Dibben MS Excel MVP
G Gary L Brown Sep 28, 2006 #3 Make sure you've selected ALL the data that you want to sort...NOT just the column you want sorted. HTH,
Make sure you've selected ALL the data that you want to sort...NOT just the column you want sorted. HTH,