GDryden
asked on
Add Text to Outline Symbols in Excel
Can text labels be incorporated next to, or above outline symbols (+), (-) in Excel to describe hidden data?
ASKER
I am not using sub-totals. I am looking for an easy way to open and close (hide/unhide) several columns, in multiple areas of the spreadsheet. The columns contain contact data, addresses, project info and notes. In essecnce, it is a dumbed-down CRM database where each row is a record and each column is a field. To make it easier to scan visually, I thought Groups would be a good way to quickly show/hide the details in each section. The down-side is, I cannot find a way to label the Outline Symbols (in the reserved space above column headers) to indicate what data is associated with each (+) ... it is fairly obvious with the (-)!
May I see a sample workbook?
Sid
Sid
ASKER
How?
How about uploading it here :)? Hope there is no confidential information there?
Sid
Sid
ASKER
Not a problem. I was just getting started when I discovered the limitation.
F2F-CONTACT-LOG.xlsm
F2F-CONTACT-LOG.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, but shapes take too much formating and tweaking to be practical. I think I will create my own buttons to hide/unhide the columns.
Thanks for the help. I'm sure whatever I decide, I'll be back!
Thanks for the help. I'm sure whatever I decide, I'll be back!
I think I will create my own buttons to hide/unhide the columns.
Yes you can do that. Let me know if you need help there.
Sid
Sid