| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
| is there a forumla to hide rows? | Excel Worksheet Functions | |||
| hide column but show chart | Charts and Charting in Excel | |||
| Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) | |||
| Excel - if cells = 0, how to conditionally hide rows in chart | Excel Worksheet Functions | |||
Linear Mode
