Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Add Text to Outline Symbols in Excel

Posted on 2011-02-14
9
320 Views
Last Modified: 2012-05-11
Can text labels be incorporated next to, or above outline symbols (+), (-) in Excel to describe hidden data?
0
Comment
Question by:GDryden
  • 5
  • 4
9 Comments
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34890613
If you are referring to SubTotals then yes, it is possible. How are you adding subtotals? Manually or by code?

Sid
0
 

Author Comment

by:GDryden
ID: 34890916
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
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34890948
May I see a sample workbook?

Sid
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:GDryden
ID: 34891137
How?
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34891175
How about uploading it here :)? Hope there is no confidential information there?

Sid

0
 

Author Comment

by:GDryden
ID: 34891337
Not a problem.  I was just getting started when I discovered the limitation.
F2F-CONTACT-LOG.xlsm
0
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 500 total points
ID: 34891389
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
 

Author Comment

by:GDryden
ID: 34891510
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
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34892179
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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question