Abraxas
Explorer
Two simple questions (I think), but I can't find answers right now.
I have a spread sheet in excel made up of a dozen or so worksheets. The first sheet has a column of data that is repeated on the other 11 or so. I want to run a sort on this column on the first sheet and have the others also be sorted with all the other columns of data on those other sheets sorted at the same time. How do I do this? I haven't been able to find a way to link the cells in the other columns on the other pages to the one column that will be sorted.
Is there a way to change the default sort conditions? Right now I am sorting a column of text, and sorting using the sort button on the tool bar always treats the first entry as a column header.
Thanks for any help
I have a spread sheet in excel made up of a dozen or so worksheets. The first sheet has a column of data that is repeated on the other 11 or so. I want to run a sort on this column on the first sheet and have the others also be sorted with all the other columns of data on those other sheets sorted at the same time. How do I do this? I haven't been able to find a way to link the cells in the other columns on the other pages to the one column that will be sorted.
Is there a way to change the default sort conditions? Right now I am sorting a column of text, and sorting using the sort button on the tool bar always treats the first entry as a column header.
Thanks for any help