Hidden Rows

  • Thread starter Thread starter Gary Thomson
  • Start date Start date
G

Gary Thomson

Hi there,

I came across this in a workbook that was sent to me, but
have no idea how to do it:

There are several columns that are hidden when the
workbook is first open. Hoever, just above the column
headings (i.e. between the column heading and the
toolbars) is a + sign that I can click on which reveals
all the hidden columns. It then changes to a minus which
will hide all the columns again.

There is also a "1" box and a "2" box just below where the
active cell reference is displayed - clicking the "2"
reveals the hidden rows, and clicking the "1" hides the
rows again, exactly the same as the "+" and "-" signs do.

How is this done??

Many Thanks

Gary.
 
This is done in the Data>Group And Outline menu.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top