How to easily locate hidden rows in a large worksheet?
 

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.

How to easily locate hidden rows in a large worksheet?
 

Take a look at the help file dealing with outlining tables and lists, or
even look at subtotals.

Microsoft Excel HelpAnalyzing and Managing DataSummarizing Data in Lists
and TablesOutlining

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

"Alberta Peach" wrote in message
...
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.