Saving Sort Settings
I have 2 workbooks set up exactly the same way but with different data. When
I go to sort one spreadsheet, it keeps the last sort options that I had. On the other spreadsheet, it will not save the settings so I have to pick them each and every time. How can I avoid this? I cannot see what I have done differently on one sprdsht than the other. I have even tried saving a copy of the one that works and replacing the data with the sprdsht that doesn't. It just keeps defaulting to the column that my cursor is in at the time. |
Saving Sort Settings
If you're always doing the same kind of sort, you could record a macro when you
do it once and then just rerun that macro whenever you wanted. ucfchick wrote: I have 2 workbooks set up exactly the same way but with different data. When I go to sort one spreadsheet, it keeps the last sort options that I had. On the other spreadsheet, it will not save the settings so I have to pick them each and every time. How can I avoid this? I cannot see what I have done differently on one sprdsht than the other. I have even tried saving a copy of the one that works and replacing the data with the sprdsht that doesn't. It just keeps defaulting to the column that my cursor is in at the time. -- Dave Peterson |
Saving Sort Settings
Ahhhh - didn't even think of that - thanks! Works even better than doing a
manual sort. "Dave Peterson" wrote: If you're always doing the same kind of sort, you could record a macro when you do it once and then just rerun that macro whenever you wanted. ucfchick wrote: I have 2 workbooks set up exactly the same way but with different data. When I go to sort one spreadsheet, it keeps the last sort options that I had. On the other spreadsheet, it will not save the settings so I have to pick them each and every time. How can I avoid this? I cannot see what I have done differently on one sprdsht than the other. I have even tried saving a copy of the one that works and replacing the data with the sprdsht that doesn't. It just keeps defaulting to the column that my cursor is in at the time. -- Dave Peterson |
All times are GMT +1. The time now is 09:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com