View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default trouble grouping rows/columns

When you click on Tools|Protection, do you see "Protect Sheet" or "Unprotect
sheet"?

You may notice that lots of icons on the standard and formatting toolbar are
disabled, too.

sorielly wrote:

How do I check if the worksheet is protected... it may have inadvertently
been protected by a colleague.

multiple sheets were not selected... any other suggestions?

Thanks!!

"Dave Peterson" wrote:

Is that worksheet protected?

Any chance you have multiple sheets selected? (Look for [Group] in the title
bar.)

sorielly wrote:

Not sure what happened, but i can no longer use the group function for rows
or coumns in one of the worksheets in a file. Is there any way to fix this?

Thanks!


--

Dave Peterson


--

Dave Peterson