Excel 2007 Sorting Question

  • Thread starter Thread starter John M
  • Start date Start date
J

John M

Hello,

I am a new user to Excel 2007. I am having a problem with the “Sortâ€
feature. In Excel 2003 whenever I sorted a worksheet the sort range and
choices were saved for the next time. In Excel 2007 I have to re-select
every time the parameters for the sort even though they will never change.

Is there a way to make the program save the sort selections?

Thank you,
John M
 
I don't see any difference in behavior, although it's possible there is
because the UI was significantly enhanced. Here's what I did:

-Created a small table with headers.
-Selected a cell in the table.
-Opened the Sort dialog and selected to sort by the second column,
descending ('largest to smallest' in Excel 2007) .
-Did the sort.
-Opened the Sort dialog again.

In both Excel 2003 and 2007 my selection of sorting by the second column,
etc., was preselected.

--
Jim
| Hello,
|
| I am a new user to Excel 2007. I am having a problem with the "Sort"
| feature. In Excel 2003 whenever I sorted a worksheet the sort range and
| choices were saved for the next time. In Excel 2007 I have to re-select
| every time the parameters for the sort even though they will never change.
|
| Is there a way to make the program save the sort selections?
|
| Thank you,
| John M
|
 
Back
Top