View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default How to create collapsible sections in Excel

And while you're "tinkering around", as Max suggests,
here's some keyboard shortcuts:

Select the Row or Column range, then;

To group,
<Shift <Alt <RightArrow

To ungroup,
<Shift <Alt <LeftArrow

To retain the Groups, but toggle hide/unhide the symbols,
<Ctrl <8
Using the "8" that's under the function keys, *not* from the num keypad.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Max" wrote in message
...
Tinker around ..
Select the rows/cols, then click Data Group and Outline Group/Ungroup
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Tess" wrote:
I'd like to be able to create collapsible sections in an Excel worksheet
(2003).
So a column would appear down the left-hand side which would have the
equivalent of + and - that could be clicked to expose/hide the rows within
a
specified range.
Has anyone done that?
Thanks for any tips.