Expand & Collapsing Rows/columns
I have seen on other Spreadsheets a expanding and collapsing option for excessive amounts of data.
How do you do this ?
To be more informative. It is tha same type of option you have on folders in Windows Explorer.
Similar Excel Video Tutorials
Hide Columns by Grouping
- See how to hide columns using the Grouping feature. The Grouping feature will had a collapse and Expand plus above the column for easy hiding and unhi ...
Is there a shortcut to expand and collapse groups of rows or columns (the +/-
grouping sets that can be made)?
Is there any way to get the [+] and [-] collapsing menu system on across columns, as well as on rows. I basically want a user friendly way to show/hide detailed workings, without using macros or the row/column hide/unhide system.
I have rows of data that I want to group to enable expanding/collapsing for easier viewing.
I'd also like to be able to protect the sheet so some of the cells cant be changed.
However when I protect the sheet and select the +/- to expand/collapse Excel returns a message that you cannot use this command on a protected sheet.
Any way that I can actually do this?
Is there any way to protect the contents of the cells while still allowing the expanding and collapsing of the grouped rows?
Happy Masters to all,
I need to find a way to expand all groupings (rows) so that my routine that enters the data from a form to the sheet will work.
The problem is the data entry code barfs if the groupings are in their grouped state. I need to expand all groups, write the data to the sheet, then return the grouping to their original state.
Other than adding grouping via code, I have no idea how else to manipulate the groupings.
i am doing a subtotal on my report and for some reason, i am not seeing the little 1, 2, 3, and the pluses and minuses on the left size of the spreadsheet. the plus will expand the data to show the detail for each category's subtotal and the minus will collapse the data to only show the subtotal per category.
the subtotal is working, but i'm not sure why i can't expand and collapse the subtotals.
I have grouped a number of rows in my excel sheet so I can collapse the rows
into 1 row.
I then want to protect the worksheet from end users however I also want them
to be able to expand and collapse the group with the small grey plus/minus
box that appears next to the grouped column rows.
Currently when i put protection on the worksheet it protects the sheet but
it also restricts users from expanding/collapsing the grouped rows. Is there
a way around this?
Thanks in advance.
I am working on a document where I want people to input text into a text box. I want to give them enough room to write, but would like the text boxes to automatically expand so that people can type in any amount of text. If you manually expand the box, this hides data that is below the text box (the 'automatic size' option in the text box properties only makes the text box expands sideways - I want it to expand downwards).
The text box option in the control toolbar does the same - it hides the data below when expanding (plus the auto size function makes the box almost dissapear if you delete its content)
Is there a macro I could use to make a regular text box expand without hiding the data below? Alternatively, I thought a macro (linked to a button dubbed "Click here to expand the text box") could be used to expand the row height (when the "move and size with cells" option is on), but it would need to expand every time the button is clicked...
I'm no expert in VB but can make a macro work if it is ready to use
Can anyone help?
I am using command buttons to link to graphs. The command buttons are located within columns that I am making collapsable/expandable. Whenever I expand the columns, the command buttons do not maintain their original position and stack on top of each other. How can I manipulate them so they stay in the original position and remain viewable after the columns have been expanded?
When clicking on the grouping numbers (to expand / collapse all groupings in that level) the sheet (heavily calculated) can hang for a long period before collapsing / expanding all groups.
Is there a way to programmatically catch the
Envet and stop calculation before it starts?
This may be something simple, but we're a little frustrated by this. We have a sheet that is in the form of a calendar. Each day uses 2 columns, so we're trying to merge and center these two columns. So that part's easy. We want to use Text wrap, which again is easy.... Then when we double click on the row to automatically resize the row, it doesn't do what it's supposed to. It leaves the row at the one row height instead of resizing it to 2 or 3 rows height... Is there a way to do this, or do I need some sort of macro to allow this to happen?? Thanks...
I need to figure out how to have a column collapse. NOT HIDE it, though. So that there's an icon and I can just click it to expand it or collapse it. Thanks.
I suspect I need a class module for this...
How do I trap the event when a user chooses to expand / collapse outlines (columns in this instance) on a worksheet?
Basicallly, when attempting to expand I want to prompt the user to enter a password and then unprotect the sheet. And if collapsing to prompt again and then protect the sheet. I have this bit covered, just not sure how to trap the event.
In Excel 2003, how do you group cell rows into collapsable regions that can be expanded and contracted with the little plus and minus signs? Similar to the Folders view in Windows Explorer.
I've got a problem with grouping and collapsing data.
I've got a schedule of more than 3000 items and I wanted to group the data into the susections. That part was not a biggie.
However, I encountered a problem when I was trying to collapse the group. Please have a look at the attachment. Say I want to collapse section 2.1 and that is not a problem. But then I cannot collapse section 2.2. although it has been groupes.
Can someone advise?
Thanks a lot,
Greetings. I posted this issue on another forum a couple of days ago but got no replies, so I thought I would see if anyone here could help.
I'm developing a userform with a multipage object on it with four tabs. Three of them have treeview (tvw) objects. I noticed a delay in switching from one tvw tab to the other, but didn't think much of it until I switched to the 4th tab, and then back to one of the others. In that case, all of the nodes in the tvw showed up as expanded, though they hadn't been before.
To find what was triggering that, I put debug stops on the tvw Expand and Collapse events. I found that when I switch from one tvw to another, for each node that was collapsed it fires the Expand event and then the Collapse event. For each node that was expanded, it fires the Expand event twice. This explains the delay I had noticed, and happens when I go from one tvw tab to another. When I go from the non-tvw tab to a tvw tab, it does the same thing, except instead of expanding and then collapsing the collapsed nodes, it expands them twice also, so they end up expanded.
I can't find anything in my code that would trigger these events, and can't account for the difference in which tab I'm coming from. I looked at the call stack during the events, and they show [<Non-Basic Code>] below the event. I suppose I could live with the delay, but I don't want the nodes expanding themselves.
All of this happens before the Multipage Change event fires.
Any ideas? Thanks in advance!
I like to color subtotal rows and columns in a distinct color.
Of course, when a field is collapsed, the corresponding subtotals are still displayed and keep the same values, only the details are not shown.
I am a little bit disturbed that when collapsing a field, the color that I have chosen for "totals" is not used anymore to format the corresponding subtotal row or column. Since the numbers and their meaning remain the same as before collapsing, I would greatly prefer that they also keep the same format.
In other words, concerning expanded or collapsed subtotals, I would like to keep their format in relation to their meaning, which is the same with the detail being displayed or without the details being displayed.
Would you know an easy way to do that?
Eventually, would it be possible to define that as a re-usable style?
I would re-use that at least 100 times !
Thanks for your suggestions,
I have created a userform with Command Buttons to open various spreadsheets that we use very often. What I would like to do is add some additional buttons that would open Windows Explorer in a specific folder. Even better if it would default to the "Search" option. Can this be done?
Does anyone know a way to trigger an event by expanding or collapsing the "group and outline" buttons? I want to fire off a module that changes the size and color of particular cells when the grouping button is clicked on.
If a user opens a workbook in read only becuase someone else is locking it would they still be able to manipulate a pivot chart in the workbook. Mainly just collapsing and expanding groups.
We have an SSRS report that gets exported to Excel. due to a bug in SSRS 2005, it is exporting the report with all the result groupings expanded. Is there a way to have Excel collapse everything all at once, or does the user have to collapse the results one grouping at a time?
I want to be able to collapse and expand lines on a worksheet using the outline tool, but at the same time leave graphs unaffected by the movement of the rows.
At the moment when I group rows together by clicking on the minus sign, my graphs shrink. Is there a way of fixing the position of the graphs so that it is unaffected by the grouping. Or is it possible to only apply the grouping to certain collumns so that my data would collapse, but leave the graph still visible
If anyone can help I would really appreciate it. This is driving me crazy.
Is it possible to use a loop thru a list of names in col A of a worksheet and create new folders in Windows Explorer with these names?
If in Col A was a list of states:
can a macro be run to create folders in C:\Test with these state names?
I'm a newbie with Tables in Mac Office 11. How do you assign a formula to an entire column in a table so that whenever you add a row the formula is populated? I believe it is called a column formula and basically means that if you change the formula in any cell in that column that ALL cells in that column are updated?