Hidden Rows

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

 

[Bob Phillips]

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)

 

[Frank Kabel]

Hi
this seems to be a grouping of coluns/rows.
Have a look at 'Data - Grouping'