Keyboard shortcut,
To Group:
Select the entire Column A:C,
<Shift <ALt <RightArrow
Select Column E:G
Do the same thing
NOTE - You *must* leave a row or column between groups,
Otherwise XL joins them together as a single Group.
To Ungroup:
Select Columns or Rows:
<Shift <ALt <LeftArrow
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"bob sacco" <bob
wrote in message
...
I already did this in an old excel worksheet but I CAN'T remember HOW I DID
IT.
The result is a (plus) + and a (minus) - sign at the top of the worksheet in
row 1 at the location where you want your selected columns to either expand
or collapse.
I need to once again implement this handy formatting trick but for the life
of me remember how I did it....so frustrating!
Anyone out ther know how to do this?