View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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