trouble grouping rows/columns
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! |
trouble grouping rows/columns
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 |
trouble grouping rows/columns
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 |
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 |
trouble grouping rows/columns
okay that doesn't seem to be the issue... any other suggestions?
"Dave Peterson" wrote: 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 |
trouble grouping rows/columns
Do you see [Shared] in the titlebar?
If the workbook is shared, there are lots of features that are disabled. sorielly wrote: okay that doesn't seem to be the issue... any other suggestions? "Dave Peterson" wrote: 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 -- Dave Peterson |
trouble grouping rows/columns
nothing in the title bar other than the name of the file...
"Dave Peterson" wrote: Do you see [Shared] in the titlebar? If the workbook is shared, there are lots of features that are disabled. sorielly wrote: okay that doesn't seem to be the issue... any other suggestions? "Dave Peterson" wrote: 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 -- Dave Peterson |
trouble grouping rows/columns
I'm out of guesses--you got any further info to share?
sorielly wrote: nothing in the title bar other than the name of the file... "Dave Peterson" wrote: Do you see [Shared] in the titlebar? If the workbook is shared, there are lots of features that are disabled. sorielly wrote: okay that doesn't seem to be the issue... any other suggestions? "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 11:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com