group/ungroup column/row buttons
You know after you group colums/rows together using Data-Group &
Outline-Group, there are these +/- buttons that let you expand/collapse those grouped columns & rows... I'm not sure what I did but those buttons are no longer showing and the grouped columns & rows now appear as if they were simply hidden. How do I get those buttons to show up again? Thanks. |
group/ungroup column/row buttons
In xl2003 menus:
Tools|Options|View tab|check outline symbols rockhammer wrote: You know after you group colums/rows together using Data-Group & Outline-Group, there are these +/- buttons that let you expand/collapse those grouped columns & rows... I'm not sure what I did but those buttons are no longer showing and the grouped columns & rows now appear as if they were simply hidden. How do I get those buttons to show up again? Thanks. -- Dave Peterson |
group/ungroup column/row buttons
Amazing! Thanks a lot.
"Dave Peterson" wrote: In xl2003 menus: Tools|Options|View tab|check outline symbols rockhammer wrote: You know after you group colums/rows together using Data-Group & Outline-Group, there are these +/- buttons that let you expand/collapse those grouped columns & rows... I'm not sure what I did but those buttons are no longer showing and the grouped columns & rows now appear as if they were simply hidden. How do I get those buttons to show up again? Thanks. -- Dave Peterson |
group/ungroup column/row buttons
Dave,
I'm having the same problem as rockhammer with a slight twist. Some of my groups no longer have the + button whilst some continue to show the + button. The hidden rows continue to operate as usual. I've tried the tools/options/view/outline symbols as per your post and this hides or shows the + button for the current visible groups but does not reactivate the groups that are currently hidden. Any help would be appreciated as I can't work out what I've done - this workbook has been in use for ages with no previous problems. Thanks in anticipation. "Dave Peterson" wrote: In xl2003 menus: Tools|Options|View tab|check outline symbols rockhammer wrote: You know after you group colums/rows together using Data-Group & Outline-Group, there are these +/- buttons that let you expand/collapse those grouped columns & rows... I'm not sure what I did but those buttons are no longer showing and the grouped columns & rows now appear as if they were simply hidden. How do I get those buttons to show up again? Thanks. -- Dave Peterson |
group/ungroup column/row buttons
I'd remove the outlining from all the data and reapply it.
Joe wrote: Dave, I'm having the same problem as rockhammer with a slight twist. Some of my groups no longer have the + button whilst some continue to show the + button. The hidden rows continue to operate as usual. I've tried the tools/options/view/outline symbols as per your post and this hides or shows the + button for the current visible groups but does not reactivate the groups that are currently hidden. Any help would be appreciated as I can't work out what I've done - this workbook has been in use for ages with no previous problems. Thanks in anticipation. "Dave Peterson" wrote: In xl2003 menus: Tools|Options|View tab|check outline symbols rockhammer wrote: You know after you group colums/rows together using Data-Group & Outline-Group, there are these +/- buttons that let you expand/collapse those grouped columns & rows... I'm not sure what I did but those buttons are no longer showing and the grouped columns & rows now appear as if they were simply hidden. How do I get those buttons to show up again? Thanks. -- Dave Peterson -- Dave Peterson |
group/ungroup column/row buttons
Thanks Dave,
That did the trick. Your help is much appreciated. "Dave Peterson" wrote: I'd remove the outlining from all the data and reapply it. Joe wrote: Dave, I'm having the same problem as rockhammer with a slight twist. Some of my groups no longer have the + button whilst some continue to show the + button. The hidden rows continue to operate as usual. I've tried the tools/options/view/outline symbols as per your post and this hides or shows the + button for the current visible groups but does not reactivate the groups that are currently hidden. Any help would be appreciated as I can't work out what I've done - this workbook has been in use for ages with no previous problems. Thanks in anticipation. "Dave Peterson" wrote: In xl2003 menus: Tools|Options|View tab|check outline symbols rockhammer wrote: You know after you group colums/rows together using Data-Group & Outline-Group, there are these +/- buttons that let you expand/collapse those grouped columns & rows... I'm not sure what I did but those buttons are no longer showing and the grouped columns & rows now appear as if they were simply hidden. How do I get those buttons to show up again? Thanks. -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 01:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com