How to easily locate hidden rows in a large worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Instead of carefully going down the worksheet and trying to identify where I
have previously hidden rows, is there a way to have a small + button on the
side where rows are hidden, or a small - button next to rows which I have
expanded?

I seem to remember being able to do that in the past with Excel 2000, but I
can't find out how to do it now. Pls help. Thanks.
 
Take a look at the help file dealing with outlining tables and lists, or
even look at subtotals.

Microsoft Excel Help>Analyzing and Managing Data>Summarizing Data in Lists
and Tables>Outlining

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000
 
Back
Top