Go Back   TechArena Community > Software > Tips & Tweaks
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to collapse rows in Excel with a plus sign to open/close

Tips & Tweaks


Reply
 
Thread Tools Search this Thread
  #1  
Old 06-01-2012
Member
 
Join Date: Dec 2011
Posts: 61
How to collapse rows in Excel with a plus sign to open/close
  

I know how to hide and show the rows in Excel, but how do it so as to leave a little plus sign in the corner that allows me to control the number of rows to expand and contract. So I just want to know whether it is possible to create such table in the Excel, if yes then how can I create such rows in Excel. If you people have any of the information then let me know.

Reply With Quote
  #2  
Old 06-01-2012
Member
 
Join Date: Nov 2009
Posts: 117
Re: How to collapse rows in Excel with a plus sign to open/close

I think this is not possible to create such rows in excel, which can collapse and expands with a plus sign. According to my information may you have seen the Data|subtotals or may be Data|Group and Outline because this both will show the outlining symbols to the left of the worksheet. So this is not possible in excel to create such thing.
Reply With Quote
Reply

  TechArena Community > Software > Tips & Tweaks
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to collapse rows in Excel with a plus sign to open/close"
Thread Thread Starter Forum Replies Last Post
Is it possible to collapse rows in Excel without plus sign Shard.K MS Office Support 2 23-02-2012 02:13 PM
What is the way to Expand/Collapse Grouped Data in a protected sheet of Microsoft Excel @nkit Trivedi MS Office Support 5 24-01-2012 01:10 PM
Disk util error when tried to open and close an excel file ? Judah Windows Software 3 28-11-2010 05:21 AM
How to expand and collapse columns in Excel Asaph Windows Software 5 31-08-2010 11:39 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 11:00 PM.