G Guest Jun 15, 2005 #1 When I am sorting a column by rows, the first row cell is being treated as a column header, why is that
When I am sorting a column by rows, the first row cell is being treated as a column header, why is that
G Guest Jun 15, 2005 #2 When you select Data->Sort, there is a choice at the bottom of the page that reads MY LIST HAS ... You obviously have HEADER ROW selected.
When you select Data->Sort, there is a choice at the bottom of the page that reads MY LIST HAS ... You obviously have HEADER ROW selected.
D Dave Peterson Jun 16, 2005 #3 Excel does its best to guess what your data is and what your header is. You could help excel guess better by giving the headers a different format--bold???
Excel does its best to guess what your data is and what your header is. You could help excel guess better by giving the headers a different format--bold???
