[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 349
  • Last Modified:

Add Text to Outline Symbols in Excel

Can text labels be incorporated next to, or above outline symbols (+), (-) in Excel to describe hidden data?
0
GDryden
Asked:
GDryden
  • 5
  • 4
1 Solution
 
SiddharthRoutCommented:
If you are referring to SubTotals then yes, it is possible. How are you adding subtotals? Manually or by code?

Sid
0
 
GDrydenAuthor Commented:
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 (-)!    
0
 
SiddharthRoutCommented:
May I see a sample workbook?

Sid
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
GDrydenAuthor Commented:
How?
0
 
SiddharthRoutCommented:
How about uploading it here :)? Hope there is no confidential information there?

Sid

0
 
GDrydenAuthor Commented:
Not a problem.  I was just getting started when I discovered the limitation.
F2F-CONTACT-LOG.xlsm
0
 
SiddharthRoutCommented:
Oh Ok. No there is no way to insert anything there. However I see that you are using shapes and they work perfectly?

Sid
0
 
GDrydenAuthor Commented:
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!
 
0
 
SiddharthRoutCommented:
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
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now