If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|