Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Inability to alpha sort in any order
My excel spreadsheet has been functioning perfectly (for over two months). I
add daily entries and, at the end of each day, have been selecting the a-z alpha sort button to shuffle the new daily entries in. Today, I find that I am suddenly losing the ability to choose that as an option. The a-z sort button is there, but is is no longer highlighted. In fact. about 90% of my option buttons are no longer highlighted. What could I or a co-worker have possibly done to cause this to happen? Any suggestions for a fix? I simply want to reactive my option buttons. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Inability to alpha sort in any order
The other user could have protected the worksheet?
Try Tools|Protection If you see Unprotect sheet, then you can select that. You may need a password, too. Or the other user may have grouped sheets. Do you see [Group] in the title bar or can you see that multiple sheet tabs are selected? If yes, then rightclick on one of the selected tabs and choose Ungroup Sheets. Arkansas Sherri M wrote: My excel spreadsheet has been functioning perfectly (for over two months). I add daily entries and, at the end of each day, have been selecting the a-z alpha sort button to shuffle the new daily entries in. Today, I find that I am suddenly losing the ability to choose that as an option. The a-z sort button is there, but is is no longer highlighted. In fact. about 90% of my option buttons are no longer highlighted. What could I or a co-worker have possibly done to cause this to happen? Any suggestions for a fix? I simply want to reactive my option buttons. -- Dave Peterson |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Inability to alpha sort in any order
Your second suggestion that I check to see if the sheets were grouped did the
trick. Everything is lit up again, and I was successfully able to do my end of day alpha sort. Thank you! "Dave Peterson" wrote: The other user could have protected the worksheet? Try Tools|Protection If you see Unprotect sheet, then you can select that. You may need a password, too. Or the other user may have grouped sheets. Do you see [Group] in the title bar or can you see that multiple sheet tabs are selected? If yes, then rightclick on one of the selected tabs and choose Ungroup Sheets. Arkansas Sherri M wrote: My excel spreadsheet has been functioning perfectly (for over two months). I add daily entries and, at the end of each day, have been selecting the a-z alpha sort button to shuffle the new daily entries in. Today, I find that I am suddenly losing the ability to choose that as an option. The a-z sort button is there, but is is no longer highlighted. In fact. about 90% of my option buttons are no longer highlighted. What could I or a co-worker have possibly done to cause this to happen? Any suggestions for a fix? I simply want to reactive my option buttons. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Needing help sort sermons in order of books of the Bible-not alpha | Excel Discussion (Misc queries) | |||
Needing help sort sermons in order of books of the Bible-not alpha | Excel Discussion (Misc queries) | |||
Can I change the sort order to Alpha before Numeric? | Excel Discussion (Misc queries) | |||
How can I sort multiple months/years WITHOUT Alpha order taking o. | Excel Worksheet Functions | |||
I want to sort worksheets in a workbook into Alpha order? | Excel Worksheet Functions |