Office Settings & Configuration

How to Fix Small Outline Group Buttons in Excel

Maira Mehtab Oct 14, 2026 869 views

Question details

The user is experiencing an issue where the outline group control buttons in a worksheet have become too small to be used effectively.

How to Fix Small Outline Group Buttons in Excel

Product: Excel
Device & OS: not provided
Scenario: Expanding or collapsing grouped rows and columns in a spreadsheet.
Observed behavior: The outline group buttons (+ and - icons) located above grouped columns and beside grouped rows are abnormally small and difficult to click.

Before you start

Ensure that your worksheet is not password-protected, as protection may restrict your ability to adjust row heights globally.

Solution 1Recommended

Increase the Row Height of the Entire Worksheet

Since the size of outline group buttons is directly tied to row dimensions, uniformly increasing the worksheet's row height will restore the controls to a usable size.

In Excel, graphical interface elements like grouping buttons scale dynamically based on the cell dimensions. If rows are compressed or set to an unusually small height, the buttons shrink. Applying a standardized row height to the whole sheet resolves this display glitch.

Select the entire worksheet

Click the Select All triangle button located in the top-left corner of the worksheet, exactly where the row numbers and column letters intersect. Alternatively, press Ctrl + A on your keyboard.

Access the Row Height setting

Right-click on any row number header on the left side of the screen, and choose 'Row Height' from the context menu.

Adjust to a normal size

In the dialog box that appears, type '25.5' (or another standard height value) and click OK. The outline group buttons should immediately return to their normal clickable size.

Increase the Row Height of the Entire Worksheet

Check Your Group Controls: Both column and row grouping controls should expand simultaneously. You can later adjust individual rows back to your preferred size if needed, but keeping a consistent baseline prevents the buttons from shrinking again.

Efficient Data Management

Easily Manage Data Outlines with WPS Spreadsheet

WPS Office Spreadsheet provides intuitive data grouping and outlining features. You can easily adjust row heights, manage complex data hierarchies, and expand or collapse groups without experiencing UI display glitches.

1. Open your file in WPS: Launch WPS Office and open your existing spreadsheet file.
2. Select the data: Click the top-left corner above row 1 to select the entire worksheet.
3. Adjust row height: Right-click the row header, choose 'Row Height', and enter your desired value to ensure crisp and clear group buttons.
4. Use Outline features: Navigate to the Data tab on the top ribbon to group, ungroup, or utilize subtotal outlines effortlessly.

100% compatible with Microsoft Excel (.xlsx) files and featuresClear, properly sized outline grouping buttons by defaultLightweight application that runs smoothly even with large datasetsFree and intuitive interface for seamless data management

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel grouping buttons suddenly become small?

Grouping buttons scale dynamically with the row heights in your worksheet. If rows are compressed, hidden, or custom heights are set too small globally, the UI elements like outline buttons shrink accordingly to match the grid layout.

Can I adjust the size of outline buttons without changing row height?

No, there is no independent setting to change the size of outline group controls. They are directly tied to the worksheet's row height settings, so you must adjust the rows to enlarge the buttons.

How do I group or ungroup rows and columns?

Select the specific rows or columns you want to group, navigate to the Data tab on the ribbon, and click 'Group' in the Outline section. To remove the grouping, select the same area and click 'Ungroup'.

What is the standard row height I should use?

The default row height typically ranges from 14.3 to 15 points depending on your default font (like Calibri 11pt) and screen scaling. However, temporarily increasing it to 25.5 points is a proven workaround to reset shrunken UI controls.

Office App Problems