Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting in Excel 2007 problem | Excel Worksheet Functions | |||
Date sorting in Excel 2007 | Excel Discussion (Misc queries) | |||
Sorting in Excel 2007 | New Users to Excel | |||
Excel 2007 - Sorting | Excel Worksheet Functions | |||
Sorting in Excel 2007 | Excel Discussion (Misc queries) |