Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving Print Settings - Customized for each user | Excel Discussion (Misc queries) | |||
HELP! Settings are not saving | Excel Discussion (Misc queries) | |||
Select rows and sort based on type | Excel Discussion (Misc queries) | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
Saving Print Settings? | Setting up and Configuration of Excel |