Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Grouping and Hide
I am trying to figure out how to get rows to group up instead of down
so that when I expand, it iexands the detail below. It keeps adding the +/- to the row below my selection instead of the top. Also, I am a little confused as to what the hide feature does. Anyone? kbeandog |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Grouping and Hide
one way:
Data/Group and Outline/Settings, uncheck the "Summary rows below detail" checkbox. Which "hide feature" are you referring to? In article .com, wrote: I am trying to figure out how to get rows to group up instead of down so that when I expand, it iexands the detail below. It keeps adding the +/- to the row below my selection instead of the top. Also, I am a little confused as to what the hide feature does. Anyone? kbeandog |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Grouping and Hide
On Mar 26, 12:03 pm, JE McGimpsey wrote:
one way: Data/Group and Outline/Settings, uncheck the "Summary rows below detail" checkbox. Which "hide feature" are you referring to? In article .com, wrote: I am trying to figure out how to get rows to group up instead of down so that when I expand, it iexands the detail below. It keeps adding the +/- to the row below my selection instead of the top. Also, I am a little confused as to what the hide feature does. Anyone? kbeandog Anyone know how to do this from VBA (i.e. uncheck those boxes)? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Grouping and Hide
Sometimes, just recording a macro will show you the code that you need:
With ActiveSheet.Outline .AutomaticStyles = False .SummaryRow = xlAbove .SummaryColumn = xlRight End With Bill wrote: On Mar 26, 12:03 pm, JE McGimpsey wrote: one way: Data/Group and Outline/Settings, uncheck the "Summary rows below detail" checkbox. Which "hide feature" are you referring to? In article .com, wrote: I am trying to figure out how to get rows to group up instead of down so that when I expand, it iexands the detail below. It keeps adding the +/- to the row below my selection instead of the top. Also, I am a little confused as to what the hide feature does. Anyone? kbeandog Anyone know how to do this from VBA (i.e. uncheck those boxes)? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping columns in excel | New Users to Excel | |||
Grouping Data in Excel | Excel Discussion (Misc queries) | |||
Excel Grouping | Excel Worksheet Functions | |||
Excel grouping & protection | Setting up and Configuration of Excel | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |