ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2007 Sorting Question (https://www.excelbanter.com/excel-programming/410064-excel-2007-sorting-question.html)

John M

Excel 2007 Sorting Question
 
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


Jim Rech

Excel 2007 Sorting Question
 
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
"John M" wrote in message
...
| 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
|




All times are GMT +1. The time now is 06:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com