-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
collapse rows
-
Is it possible to collapse rows?
If I have an item that I need to be able to expand to see the parts make it, is that possible in Excel? For example: My Apartments Base rent $700 Washer/Dryer rental $50 Utilities $30 Is there a way to collapse that into one or two rows, i.e. My Apartments $780 Or something...- charlesstricklin
- Thread
- collapse rows excel
- Replies: 1
- Forum: Excel Questions
-
M
Collapsable Cells
having some difficulty figuring out how to collapse multiple rows. Here is my example of what i'm trying to do. I already understand the Checkbox VBA codes etc. Here is the formula VBA i'm putting in. Private Sub CheckBox1_Click() [A30:H65].EntireRow.Hidden = CheckBox1 End Sub Private...- mmdmalta
- Thread
- click collapse rows end private sections
- Replies: 7
- Forum: Excel Questions
-
B
Merge or Collapse Rows without Losing Data - Not Consolidated
Hi, I've got a big file broken down into manageable sizes - about 4500 rows each. Each Unique Identity may have 1 to maybe 10/15 rows (varies). Mostly, each row contains one column of non-blank data (some have more than one cell that is non-blank). I want to merge/roll up these rows into 1 row...- billsall
- Thread
- collapse rows consolidate rows merge rows vba & excel 2007
- Replies: 0
- Forum: Excel Questions
