R
Rhonda
In Excel 2003, and for some versions before, if I sorted a selected range
(say A4:Q54) by Col A Asc, Col G Asc, and Col C Desc then Excel would remember
the sort parameters so that if I changed ranges to say B104:Z154 it would
keep those same parameters loaded and I could just simply sort my data
without having to re-enter the sort parameters all over again.
In Excel 2007, every time I change ranges, and even sometimes when I move
away from a range and then come back to an old range, I have to re-enter the
sort parameters every time.
If someone has a work around for this or knows how to get the sort order
functionality to start working the way it was before I would appreciate it.
(say A4:Q54) by Col A Asc, Col G Asc, and Col C Desc then Excel would remember
the sort parameters so that if I changed ranges to say B104:Z154 it would
keep those same parameters loaded and I could just simply sort my data
without having to re-enter the sort parameters all over again.
In Excel 2007, every time I change ranges, and even sometimes when I move
away from a range and then come back to an old range, I have to re-enter the
sort parameters every time.
If someone has a work around for this or knows how to get the sort order
functionality to start working the way it was before I would appreciate it.