N
nancy
by the complete Excel novice again. (thanks for the answers to my
leading 0 question - it worked!)
I want to sort the whole table, based on one column. The instructions
tell me to select a cell in the column I will want to sort by and sort
in ascending or desceding order.
This resulted in sorting only that column, but not keeping the
appopriate information for the entire row with that particular column.
I also tried selecting the whole column, telling Excel to 'expand my
selection, and sorting in ascending order. Same result.
I finally selected the whole table myself and sorted with the same
result - the column I am sorting by (in this case price) sorted in
ascending order, but did not sort the entire table - so now John
Smith's price is now associated with someone else's name (is this
clear)
Thanks so much. I'm so frustrated.
leading 0 question - it worked!)
I want to sort the whole table, based on one column. The instructions
tell me to select a cell in the column I will want to sort by and sort
in ascending or desceding order.
This resulted in sorting only that column, but not keeping the
appopriate information for the entire row with that particular column.
I also tried selecting the whole column, telling Excel to 'expand my
selection, and sorting in ascending order. Same result.
I finally selected the whole table myself and sorted with the same
result - the column I am sorting by (in this case price) sorted in
ascending order, but did not sort the entire table - so now John
Smith's price is now associated with someone else's name (is this
clear)
Thanks so much. I'm so frustrated.