How to easily locate hidden rows in a large worksheet?

A

Alberta Peach

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.
 
R

Ronald Dodge

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hidden rows, column copy-paste 0
Hidden cells 1
Hidden cells expanding when completing calculation 1
unhide row does not unhide the hidden rows 4
how to find out if a row is hidden 3
Text in note pane of "normal" display suddenly much larger 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Hidden rows columns won't stay hidden 0

Top