Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#

Download:

Datei 1: Demo_Gruppierung_umdrehen_oben_unten.xlsx

Excel grouping from top to bottom
 
How to flip the grouping sign from bottom to top in Excel when opening
in standardmode excel displays the grouping character below the grouping

 
In theclosed state, the grouping character is below the hidden area.

 
Flip the grouping character in Excel vba
To flip the grouping character, see the menu (Ribbonbar)->Data->for the group: Grouping at the bottom right of the
Here you can find the settings of the Excel grouping
Direction:
Main lines under Detail characters
 
In thedefault, the grouping character below the group is enabled.
If you deactivateit, then the grouping character above the group is

 
 
Flipping the grouping character when opening
To do this, you have to deactivate the checkbox

 
 
Grouping characters umgedreht
down
in the closed state, the + Plus symbol is the sign above the hidden grouped area

 
When you open it, the area is appended downwards

 
 
In the end, it may make more sense for many groupings to change the orientation as here in a month-hour write-off

 
 
Per vba Excel Macro Code

Sub Group_unten()
ActiveSheet.Outline.SummaryRow = xlBelow
End Sub

Sub Group_top()
ActiveSheet.Outline.SummaryRow =xlAbove
End Sub

 
 
 
 
 
 
Mobile
»
Excel grouping from top to bottom
»
Excel: Replace text in a selected area
»
Change Excel Adress Z1S1 R1C1 row column to A1
»
Excel: Move cursor with arrow key
»
Excel: Copy cells without empty lines

.

Contact for Jobs, Project Requests: raimund.popp@microsoft-programmierer.de