Why Excel Sheet View Does Not Preserve Collapse and Expand Settings
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.
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.
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.
Go to https://excel.uservoice.com/forums/274580-excel-for-the-web in your browser.
Click Sign in and enter the Microsoft account you use for Excel for the web.
Click the option to post a new idea or feedback request.
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.
Click Submit or Post to send the request to Microsoft.
Work around the limitation with separate worksheet copies
Use this workaround when different reviewers need different collapsed or expanded grouped states before Microsoft implements the feature.
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. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free to install the suite.
- 2. Open your Excel workbook: Launch WPS Office, choose Spreadsheets, and open the .xlsx file you need to work on.
- 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.

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.




