Collapse and Expand Rows.

srizki

Well-known Member
Joined
Jan 14, 2003
Messages
1,791
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
I have department number in column A, department name in column B and under each department I am adding description of budgeted expense, such as payroll, supplies, travel etc. I will put the total budgeted amount in the corresponding cell. So, for example, department name G & A Direct, in cell, B4 the budgeted total amount will be in C4 and the breakdown of the expense will be under it. I have around 60 departments and on average 15 expenses. Therefore I want to collapse the expense as it is possible in pivot table.
Can I do expand and collapse in the column, or is there a better way of doing this worksheet.

Regards,

 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Watch MrExcel Video

Forum statistics

Threads
1,108,910
Messages
5,525,587
Members
409,652
Latest member
strangelyangely

This Week's Hot Topics

Top