MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Collapsing and expanding columns


Posted by Borneo on June 28, 2001 8:16 AM

Hi,
I am new to Excel and I saw a neat way of showing Excel on screen i.e. expanding and collapsing columns. Can anybody show me how this is done?

Thanks


Posted by Cory on June 28, 2001 10:04 AM

I think what you're looking for is the way to "hide" and "unhide" columns. Is this right?

To hide a column(s) (or a row(s)), select the columns you wish to hide by clicking on the A, B, C, etc... tab at the top of the column. Once selected, right-click on that column and choose "hide" near the bottom of the pop-up menu. You can do one column or multiple columns. To select multiple columns that AREN'T right next to each other, select your first column, hold Control, then select the others.
To unhide them, drag your mouse cursor across the column tabs where the hidden columns are, right-click, then choose "unhide".

Any help?
Cory

Posted by mseyf on June 28, 2001 12:50 PM

from the menubar check out Data>Subtotals and Data>Group and Outline

-Mark

Posted by Borneo on July 06, 2001 7:58 AM

I have finally discovered how to do it. Go to tools, customize and check the Pivot Table toolbar.

Highlight a bunch of rows and then hit the right pointing green arrow on the Pivot Table tool bar (called Group) and voila! You can collaspe and expand columns.

Thanks for the attempt to help.