View Single Post
  #4   Report Post  
RagDyer
 
Posts: n/a
Default

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?