Can You Edit an Existing Custom View in Excel? Workarounds & Solutions
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.

- 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 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.
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.
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'.
Make the necessary changes to your workbook. This can include hiding or unhiding rows, adding new worksheets, adjusting column widths, or changing print areas.
Go back to the 'View' tab and click 'Custom Views' again. Click the 'Add...' button to create a new 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.

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. Download and Install: Get the free WPS Office suite from the official website and follow the quick installation prompts.
- 2. Open Your Workbook: Launch WPS Spreadsheets and open your existing Excel files directly, without worrying about format or layout loss.
- 3. Customize Your Views: Use the View tab in WPS Spreadsheets to easily manage your workbook layouts, freezes, and window settings.

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.




