How to Move Excel Group Summary Symbols Above or Below Detail Rows
Question details
The user wants to change the default position of the plus and minus outline symbols in a spreadsheet to appear either above or below their grouped detail rows.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Formatting grouped data in a complex worksheet to align the expand/collapse controls with the summary headers.
- Observed behavior
- The group summary controls currently display in an undesired location and need to be repositioned to match the worksheet's layout.
Ensure your worksheet already contains grouped data with visible outline symbols before adjusting their position.
Modify Data Outline Settings
Change the built-in Outline settings to position the plus and minus signs either above or below the detail rows.
By default, Excel assumes your summary rows are located below your detailed data. If your summary rows are placed above the details, you can adjust the outline settings so that the plus and minus symbols align perfectly with your headers.
Go to the 'Data' tab on the ribbon. In the 'Outline' group at the far right, click the small dialog box launcher icon in the bottom corner to open the Settings dialog.
To move the group symbols to the top of each grouped section, clear the 'Summary rows below detail' checkbox. If you want them at the bottom, ensure this box is checked.
Click 'OK'. The plus and minus symbols will immediately relocate to your preferred position on the worksheet.
Manage Your Grouped Data Easily with WPS Office
WPS Spreadsheet provides intuitive tools for grouping data and customizing outline symbols. It is completely free and seamlessly supports Microsoft Excel files.
- 1. Open WPS Spreadsheet: Launch WPS Office and open your workbook containing the grouped rows.
- 2. Navigate to the Data Tab: Click on the 'Data' tab on the top ribbon and locate the 'Group' menu.
- 3. Access Group Settings: Click on the 'Settings' option within the Group dropdown menu to open the outline preferences.
- 4. Change Symbol Position: Uncheck 'Summary rows below detail' to move your symbols to the top, then click 'OK' to save.
Frequently Asked Questions
Why are my group plus/minus signs missing entirely?
If your symbols are missing, the outline display might be disabled. You can enable them by going to File > Options > Advanced. Scroll down to 'Display options for this worksheet' and check 'Show outline symbols if an outline is applied'.
Does changing the summary row position affect my data or formulas?
No. Changing the position of the group summary symbols only alters the visual placement of the outline controls (the plus and minus signs). It does not modify your underlying data, groups, or calculation formulas.
Can I set the outline symbols to the top for the entire workbook at once?
The 'Summary rows below detail' setting is applied on a per-worksheet basis. You must adjust this setting individually for each sheet where you want the symbols moved to the top.
