Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Want help to create roll up rows in Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 24-02-2012
Member
 
Join Date: Jan 2011
Posts: 26
Want help to create roll up rows in Microsoft Excel

I have recently seen a worksheet with + boxes to the left of a row that when you click on it several related rows are revealed and the + becomes a -. When you click the - the newly reveals rows are hidden and the initial line is visible and the sign changed back to a +. Can someone tell me how this is done.

Reply With Quote
  #2  
Old 24-02-2012
Member
 
Join Date: Aug 2011
Posts: 576
Re: Want help to create roll up rows in Microsoft Excel

By Grouping. Excel 2003: Select the rows (or columns) you want to group, then use Data/Group and Outline/Group. in Excel 2007: Data tab/Group.
Reply With Quote
  #3  
Old 24-02-2012
Member
 
Join Date: Aug 2011
Posts: 539
Re: Want help to create roll up rows in Microsoft Excel

It is like drop down list. You can create that list on your own in Excel. For something you will need to use a vba code to get that animated + working. I will not recommend that. Better go for drop down list for the same.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Want help to create roll up rows in Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
How to create fixed lengh cell and rows in Microsoft Excel Henriksen MS Office Support 2 21-02-2012 04:52 PM
Need help to create a PVIFA in Microsoft Excel Limitless MS Office Support 2 17-02-2012 06:48 PM
How to make collapsible and expandable rows in Microsoft Excel AsceTic! MS Office Support 2 18-01-2012 05:55 PM
VBA to hide the rows in Microsoft Excel Lanka Boy MS Office Support 1 14-01-2012 02:12 PM
Merging duplicate names not rows copy rows into new workbook each time VBA Excel 2003 awkwardsmile Software Development 2 09-07-2009 08:57 AM


All times are GMT +5.5. The time now is 05:43 AM.