ExcelBanter - how do I hide a set of lines and using the "+" sing show them

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I hide a set of lines and using the "+" sing show them (https://www.excelbanter.com/excel-discussion-misc-queries/159759-how-do-i-hide-set-lines-using-sing-show-them.html)

JRC

how do I hide a set of lines and using the "+" sing show them

I am trying to figure out an existing spread sheet that has repeating lines
hidden until you click on the "+" sing on the left. Then they appear.

My question is how do you set this up ?

Gord Dibben

how do I hide a set of lines and using the "+" sing show them

DataGroup and Outline.

Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 11:26:04 -0700, JRC wrote:

I am trying to figure out an existing spread sheet that has repeating lines
hidden until you click on the "+" sing on the left. Then they appear.

My question is how do you set this up ?

All times are GMT +1. The time now is 02:18 AM.