I have grouped 10 columns together, so that I can expand it and collapse it easily when required. However I need few columns in that grouping to be completely hidden. As in they must never appear unless I unhide it manually.
Currently if I hide cells within a group they get hidden. But once I collapse and then expand the grouping again the cells become unhidden automatically. Can this be avoided?
Btw I use MS Excel 2007.
Is this even possible? Pls respond!
Do you create the groups manually or via a macro? It will be easier to merge the "hide columns" code along with the group columns code, if its done via a macro.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi arlu1201,
Thank you for your reply. And no I do not use macros for mainly two reasons.
1. I do not know much about it.
2. I need the sheet to be compatible for Lotus Symphony as well and as far as I have seen any VBA code or macros do not work in it.
Is it possible to do with any of Excel's default functions or formulas, or have I finally reached the limit of what can be done in Excel without VBA.
I have tested it at my end and it cannot be done without VBA.
Thank you for your help arlu1201. Glad to finally have an answer, even if it is not a positive one.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks