Office Settings & Configuration

Why Excel Sheet View Does Not Preserve Collapse and Expand Settings

Kushani NimanthikaKushani Nimanthika Nov 13, 2026 868 views

Question details

The user wants to know why Excel Sheet View does not keep grouped row or column collapse and expand states separate for each Sheet View.

Product
Microsoft Excel for the web
Device & OS
not provided
Scenario
The user is using Excel Sheet View to isolate filters and sorting for individual reviewers, but expects grouped rows and columns to stay collapsed or expanded only in the active view.
Observed behavior
Collapsing or expanding grouped rows or columns affects the worksheet structure across all Sheet Views instead of remaining local to the active view.
Before you start

Open the affected workbook in Excel for the web and confirm that grouped rows or columns are present. Because this is an Excel for the web limitation, no WPS setting can change how Microsoft Excel stores Sheet View state.

Solution 1Recommended

Submit a feature request for per-view collapse and expand settings

Use this solution when you want Microsoft to add a separate collapse and expand state for each Excel Sheet View.

Microsoft Excel currently stores grouped row and column collapse or expand state at the worksheet level, so there is no per-Sheet-View setting to enable.

1
Open the Excel feedback forum

Go to https://excel.uservoice.com/forums/274580-excel-for-the-web in your browser.

2
Sign in to your Microsoft account

Click Sign in and enter the Microsoft account you use for Excel for the web.

3
Start a new suggestion

Click the option to post a new idea or feedback request.

4
Describe the Sheet View limitation

Enter a clear title such as 'Preserve collapse and expand settings per Sheet View' and explain that grouped rows or columns currently affect all views.

5
Submit the feature request

Click Submit or Post to send the request to Microsoft.

Official feedback path: This is the Microsoft Excel feedback forum; WPS cannot enable this feature in Microsoft Excel for the web.
Free Microsoft Office alternative

Use WPS Office as a Free Spreadsheet Alternative for Excel Workbooks

Because Microsoft Excel for the web does not preserve collapse and expand settings per Sheet View, WPS Office provides a free, lightweight Office alternative with .xlsx compatibility, a familiar spreadsheet interface, and easy migration from Excel.

  1. 1. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free to install the suite.
  2. 2. Open your Excel workbook: Launch WPS Office, choose Spreadsheets, and open the .xlsx file you need to work on.
  3. 3. Work with grouped rows and columns: Use the Data tab in WPS Spreadsheets to group, ungroup, expand, or collapse rows and columns and save the workbook.
Opens and edits Excel .xlsx workbooks, including grouped rows and columnsFree and lightweight Office suite for everyday spreadsheet tasksFamiliar ribbon and menu layout to reduce the learning curveNo subscription required for daily spreadsheet editing and sharing
microsoft office alternative - wps office

Frequently Asked Questions

Does Excel Sheet View save separate collapse and expand settings for each user?

No. Excel currently does not provide a separate Collapse or Expand setting for each Sheet View. Collapsing or expanding grouped rows or columns affects the worksheet structure across all Sheet Views.

Where can I request this Excel feature?

Submit the suggestion through the Excel feedback forum at https://excel.uservoice.com/forums/274580-excel-for-the-web and include your scenario for per-view collapse and expand controls.

Can WPS Office fix Excel Sheet View behavior?

WPS Office cannot change how Microsoft Excel for the web handles Sheet View, but it can open and edit your .xlsx workbooks as a free and lightweight alternative.

What can I do if I need different collapse states for different reviewers right now?

Create a separate worksheet copy for each reviewer and apply the desired collapsed or expanded state to each copy. This is a workaround, not a Sheet View fix.

Does this limitation also apply to hidden rows and columns in Sheet View?

Users have reported similar requests for hidden rows and columns. Currently, Excel does not preserve those settings per Sheet View, so submit that request through the same feedback forum.