![]() |
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 |
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