Office Settings & Configuration

How to Fix Excel Auto Outline Disabled or Change Symbol Position

Olivia Miller Oct 8, 2026 871 views

Question details

The user wants to change the position of expand and collapse outline symbols, but the Auto Outline feature is unavailable, greyed out, or displays an error.

How to Fix Excel Auto Outline Disabled or Change Symbol Position

Product: Microsoft Excel
Device & OS: not provided
Scenario: Adjusting the layout and position of outline symbols for grouped data.
Observed behavior: The Auto Outline option is disabled or shows an error, preventing the user from modifying the outline layout.

Before you start

Ensure that your active cell is not located inside a formatted Excel Table, as outline and grouping features are often disabled within tables.

Solution 1Recommended

Use Outline Settings to Change Symbol Positions

Auto Outline is designed to create outlines automatically, not adjust symbol layouts. Use the dedicated Outline Settings dialog to change their placement.

Many users mistakenly try to use the Auto Outline button to change how expand (+) and collapse (-) symbols appear on their sheet. Instead, you must use the Outline settings menu to dictate whether summary rows appear above or below your details.

Navigate to the Data tab

Open your Excel workbook and click on the Data tab in the top ribbon.

Open Outline Settings

Locate the Outline (or Group) section at the far right of the Data ribbon. Click the small dialog box launcher icon in the lower-right corner of this section.

Adjust symbol positions

In the Settings dialog box, check or uncheck 'Summary rows below detail' or 'Summary columns to right of detail' according to your preference, then click OK.

Use Outline Settings to Change Symbol Positions

Settings Applied: Your expand and collapse symbols will immediately shift to match your new summary row or column configuration.

Solution 2

Convert Excel Table to a Range

If the Outline settings and Auto Outline buttons are completely greyed out, your data is likely formatted as an Excel Table.

Powerful Spreadsheet Software

Group and Outline Data Easily with WPS Spreadsheet

WPS Office provides a highly intuitive spreadsheet tool with robust grouping and outlining features. It makes organizing your data and changing expand or collapse symbol positions incredibly simple without dealing with greyed-out menus.

1. Open your file: Launch WPS Spreadsheet and open your workbook.
2. Access Group tools: Navigate to the Data tab on the main ribbon and find the Group function.
3. Adjust Settings: Click the Settings icon next to Group to quickly modify summary row or column positions.
4. Apply outlines: Apply your custom settings and use the intuitive plus and minus symbols to navigate your grouped data effortlessly.

Fully compatible with Microsoft Excel (.xlsx and .xls) formatsIntuitive Data tab for quick grouping and outlining without confusing menusFree, lightweight, and fast to load for all usersClear interface for easily adjusting summary rows and columns

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Group or Auto Outline button greyed out in my spreadsheet?

This typically happens if your active cell is inside a formatted Table, if multiple sheets are grouped together, or if the worksheet is protected. Converting the table to a range or unprotecting the sheet will re-enable the buttons.

Can I remove all outlines from my worksheet at once?

Yes. You can quickly remove all outlines by navigating to the Data tab, clicking the drop-down arrow under Ungroup, and selecting Clear Outline.

What is the actual purpose of the Auto Outline feature?

Auto Outline automatically groups data that contains formulas summarizing specific ranges, such as subtotals. It is not designed to manually format the layout or change the physical location of the expand and collapse symbols.

Office App Problems