Office Settings & Configuration

How to Restore Missing Excel Functions and the Sum Button

Guest Writer Oct 12, 2026 869 views

Question details

The user is unable to find the Sum button and other function controls on the Excel ribbon, which seem to be replaced or hidden by cell-formatting options.

How to Restore Missing Excel Functions and the Sum Button

Product: Excel
Device & OS: not provided
Scenario: Attempting to access the Sum function and other calculation tools in an Excel workbook.
Observed behavior: The function controls are hidden or pushed off-screen, and the Cell Styles section occupies the majority of the visible ribbon area.

Before you start

Ensure your computer's display resolution and scaling settings are configured correctly, as these can affect how the application ribbon is displayed on your screen.

Solution 1Recommended

Maximize or Resize the Excel Window

The most common reason for missing ribbon buttons is a narrow application window. Maximizing the window expands the ribbon to show all available controls.

When the Excel window is not fully expanded, low screen resolution or high display scaling can cause the ribbon to collapse certain sections. This often hides function tools like the Sum button, prioritizing formatting sections like Cell Styles instead.

Double-click the title bar

Hover your cursor over the top title bar of the Excel window and double-click it to instantly maximize the application.

Use the Maximize button

Alternatively, click the square 'Maximize' icon located in the top-right corner of the Excel window.

Scroll or resize manually

If you prefer a smaller window, click and drag the left or right edges of the window to make it wider until the functions reappear on the right side of the ribbon.

Functions Restored: Once the window is wide enough, the Cell Styles section will adjust, and your Sum button and other function controls will become visible again.

Solution 2

Customize the Ribbon to Remove Unwanted Sections

If the Cell Styles section occupies too much space on a smaller screen, you can remove it from the ribbon to make room for function buttons.

Efficient Data Management

Use WPS Spreadsheet for a Responsive and User-Friendly Ribbon

WPS Office offers an intuitive interface where functions like the AutoSum button are always easily accessible. It smartly adapts to your screen size to ensure you never lose track of essential tools.

1. Download and Install: Get WPS Office for free from the official website and install it on your device.
2. Open your Workbook: Launch WPS Spreadsheet and open your existing Excel file.
3. Access the Sum Tool: Navigate to the 'Formulas' tab or the 'Home' tab to find the AutoSum button readily available on the ribbon.
4. Adjust the Window: Double-click the title bar to maximize the window and ensure all ribbon tools are fully displayed.

Highly responsive UI that seamlessly adapts to different screen sizes and resolutions.Fully compatible with Microsoft Excel (.xlsx, .xls) formats for easy file sharing.Features a prominent AutoSum tool and an extensive, easy-to-navigate formula library.Lightweight application that runs smoothly even on older devices without hiding essential tools.

microsoft office alternative - wps office

Frequently Asked Questions

Why do some buttons disappear from my Excel ribbon?

Ribbon buttons often disappear or collapse into smaller icons when the application window is too narrow, your screen resolution is low, or your display scaling is set too high. Maximizing the window usually restores them.

Can I permanently hide the Cell Styles section in Excel?

Yes, you can hide it by right-clicking the ribbon, selecting 'Customize the Ribbon', finding the 'Styles' group under the Home tab, and clicking the 'Remove' button.

How do I change my display scaling if maximizing the window doesn't work?

On Windows, go to Settings > System > Display, and look for the 'Scale and layout' section. Reduce the scaling percentage (e.g., from 150% to 100%) to fit more items on your screen.

Office App Problems