MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hiding and Unhiding colums with a + - button above Column


Posted by Dominic on March 20, 2001 6:06 AM

I have seen a spreadsheet with a + - button above the column headings that hides and unhides column, I have done the same with a macro and normal buttons, but how is this done?


Posted by Dave Hawley on March 20, 2001 6:08 AM


You mean Data>Subtotals ?

Dave
OzGrid Business Applications

Posted by Dominic on March 20, 2001 6:13 AM

Once again ... Thanks

Posted by Mark W. on March 20, 2001 6:22 AM

See the Data Group and Outline menu command.

Posted by Dominic on March 20, 2001 6:42 AM

Thanks, exactly whet I needed