Office Settings & Configuration

Can You Edit an Existing Custom View in Excel? Workarounds & Solutions

Khadija KhanKhadija Khan Nov 2, 2026 869 views

Question details

The user wants to know if it is possible to modify an already saved custom view in Excel, specifically to add or remove worksheets from the view.

Can You Edit an Existing Custom View in Excel?
Product
Microsoft Excel
Device & OS
not provided
Scenario
Updating a previously saved workbook layout to reflect new worksheet visibility, filters, or print settings.
Observed behavior
Excel does not offer an option to directly edit or modify the worksheet selection of an existing custom view. Users are forced to recreate the view entirely.
Before you start

Before deleting your current custom view, apply it to your worksheet and note down its specific configurations (such as hidden columns, active filters, and print settings) so you can accurately replicate it.

Solution 1Recommended

Recreate the Custom View with Updated Settings

Since Excel inherently lacks an 'Edit' button for custom views, the standard workaround is to apply the view, adjust your settings, and save it as a new view (overwriting the old one).

Microsoft Excel does not currently support dynamically adding or removing worksheets from a saved custom view. To update a view, you must recreate it.

By using the exact same name as your old custom view, Excel will automatically overwrite the previous configuration with your updated layout.

1
Apply the existing view

Navigate to the 'View' tab on the Excel ribbon, click on 'Custom Views' in the Workbook Views group, select the view you wish to modify, and click 'Show'.

2
Adjust your worksheet settings

Make the necessary changes to your workbook. This can include hiding or unhiding rows, adding new worksheets, adjusting column widths, or changing print areas.

3
Create a new custom view

Go back to the 'View' tab and click 'Custom Views' again. Click the 'Add...' button to create a new view.

4
Overwrite the old view

Type the exact name of the custom view you want to replace and click 'OK'. Excel will ask if you want to overwrite the existing view; confirm to save your edited settings.

Recreate the Custom View with Updated Settings
Send Feedback to Microsoft: You can request official support for editing custom views by pressing Windows + F to open the Feedback Hub and submitting a feature request to Microsoft.
Free Microsoft Office alternative

Manage Spreadsheets Easily with WPS Office

If rigid spreadsheet settings and missing features slow down your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible, and user-friendly spreadsheet environment that makes data management and layout customization simple.

  1. 1. Download and Install: Get the free WPS Office suite from the official website and follow the quick installation prompts.
  2. 2. Open Your Workbook: Launch WPS Spreadsheets and open your existing Excel files directly, without worrying about format or layout loss.
  3. 3. Customize Your Views: Use the View tab in WPS Spreadsheets to easily manage your workbook layouts, freezes, and window settings.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight installation with blazing fast loading times for large datasets.Intuitive tabbed interface makes managing multiple worksheets effortless.Completely free to use with a powerful suite of data analysis tools.
microsoft office alternative - wps office

Frequently Asked Questions

Where is the Custom Views option located in Excel?

You can find the Custom Views feature by navigating to the 'View' tab on the Excel ribbon. It is located in the 'Workbook Views' group on the far left.

Why is the Custom Views button grayed out in my workbook?

The Custom Views feature is automatically disabled if your workbook contains an Excel Table (created via Insert > Table). You must convert all tables back to normal ranges to use custom views.

What settings are actually saved in an Excel Custom View?

A custom view remembers specific display settings including hidden rows and columns, active filter configurations, window size and position, zoom levels, and specific print settings.

Can I share a custom view with other users?

Yes, custom views are saved within the workbook itself. When you share the Excel file with another user, they can access your saved custom views from the View tab.