ExcelBanter - Hide and show Rows

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

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

- - Hide and show Rows (https://www.excelbanter.com/excel-discussion-misc-queries/22696-hide-show-rows.html)

Duane

Hide and show Rows

I have been sent a couple of spreadsheets that have a column on the left with
'+' and '-' icons to show and hide rows. Is this a macro? Or a feature I
cant find?

Duane

Okay, I found it. "Group" was the function I was looking for.

Duane

"Duane" wrote:

I have been sent a couple of spreadsheets that have a column on the left with
'+' and '-' icons to show and hide rows. Is this a macro? Or a feature I
cant find?

Dave Peterson

Data|subtotals can add those +/- symbols, too.

Duane wrote:

Okay, I found it. "Group" was the function I was looking for.

Duane

"Duane" wrote:

I have been sent a couple of spreadsheets that have a column on the left with
'+' and '-' icons to show and hide rows. Is this a macro? Or a feature I
cant find?

--

Dave Peterson

All times are GMT +1. The time now is 10:01 PM.