Remove Custom View: What It Does in Excel & Google Sheets

Removing a custom view in Excel or Google Sheets deletes a saved snapshot of your display settings (like hidden rows, filters, and column widths) so it no longer appears in the View list. You can delete any custom view you created, but you cannot delete the built-in “Custom Views” feature itself. This article explains exactly how to remove views, what happens to your data, and common pitfalls.

What a Custom View Actually Stores

A custom view is a saved set of display and print settings, not a copy of your data. In Excel, it captures:

• Hidden rows and columns
• Row height and column width
• Filter settings (which rows are filtered out)
• Sheet selection and zoom level
• Print settings (margins, page breaks, print area)
• Window pane freeze state

In Google Sheets, the equivalent feature is called a “Filter view” (under Data → Filter views), which stores only filter criteria and sort order, not column widths or print settings. When you remove a custom view, you are only deleting that saved snapshot—none of the underlying data or formatting in the sheet changes.

How to Remove a Custom View in Excel (Windows & Mac)

The steps differ slightly between Windows and Mac, but the principle is the same.

1. Go to the View tab on the ribbon.
2. Click Custom Views (in the Workbook Views group).
3. In the dialog box, select the view you want to delete from the list.
4. Click Delete, then confirm when prompted.

On a Mac, the Custom Views button is also under the View tab, but the dialog may look slightly different—just select the view and press the minus (−) button or Delete key. You can delete multiple views one at a time; there is no “select all” option.

How to Remove a Filter View in Google Sheets

Google Sheets uses a separate system, so the removal process is different.

1. Open the sheet and click Data in the top menu.
2. Hover over Filter views to see a list of saved views.
3. Click the X next to the view name you want to remove.
4. Confirm the deletion when prompted.

Alternatively, if you are currently in a filter view, you can click the green filter icon in the top-right corner of the sheet and select Delete from the dropdown. Deleting a filter view does not affect the data—it only removes the saved filter criteria.

What Happens to Your Data After Removal?

Nothing happens to the data itself. Custom views and filter views are purely metadata—they store instructions about how to display the sheet. When you delete a view, the underlying cells, formulas, and formatting remain untouched. The only immediate change is that the view disappears from the list, so you can no longer switch back to that exact display configuration with one click.

If you delete a view while it is currently active, the sheet will revert to the default view (all rows and columns visible, filters cleared, zoom at 100%). Your data is still there, just displayed differently. This is a common point of confusion: people worry that deleting a view will delete hidden rows or filtered-out rows. It will not.

Common Mistakes and Troubleshooting

Several issues can arise when trying to remove custom views:

• Button greyed out: In Excel, the Custom Views button is disabled if the sheet is in a table (ListObject) or if the workbook is shared. You must convert the table to a range or unshare the workbook first.
• View not showing in list: If you created a view in a different workbook, it won’t appear. Custom views are stored per workbook, not per application.
• Cannot delete the last view: Excel allows you to delete all custom views, leaving the list empty. There is no minimum count.
• Filter view “X” not visible: In Google Sheets, the X only appears when you hover over the view name in the list. If you don’t see it, move your mouse over the row.
• Accidental deletion: There is no undo for deleting a custom view. Once confirmed, it’s gone. You would need to recreate it manually.

Alternatives to Custom Views

If you find yourself constantly creating and deleting views, consider these alternatives:

• Excel Tables: Convert your range to a table (Ctrl+T). Tables remember filter states per sheet and are easier to manage.
• Named Ranges + Hyperlinks: Create named ranges for different sections and use hyperlinks to jump to them, avoiding display changes altogether.
• Google Sheets Filter Views: These are more lightweight than Excel’s custom views and can be shared with specific people without affecting others’ views.
• Slicers: In Excel, slicers provide a visual way to filter data without saving views.
• Separate Sheets: If you need different layouts, copy the data to separate sheets and format each one differently.

Frequently Asked Questions

Can I recover a deleted custom view?

No. Excel and Google Sheets do not have a recycle bin for custom views or filter views. Once you confirm deletion, the view is permanently gone. Your only option is to recreate it manually by setting up the same hidden rows, filters, and print settings.

Does deleting a custom view remove hidden rows?

No. Hidden rows are a property of the worksheet, not the view. Deleting a view only removes the saved snapshot of which rows were hidden. The rows themselves remain in the sheet—they just become visible again if the view was active when deleted.

Why is the Custom Views button greyed out in Excel?

The button is disabled when the workbook is shared (under Review → Share Workbook) or when the active sheet is an Excel table. Convert the table to a range (right-click → Table → Convert to Range) or unshare the workbook to enable the button.

Can I delete a custom view in Excel Online?

No. Excel Online (the web version) does not support custom views at all. The feature is only available in the desktop versions of Excel for Windows and Mac. If you need to remove a view, open the file in the desktop app.

Will deleting a filter view in Google Sheets affect other collaborators?

Only if they are currently using that view. Filter views are shared by default, so deleting one will remove it for everyone. However, if a collaborator has the view active, they will see a message that the view was deleted and their filter will be cleared. Their data is not affected.

What is the difference between a custom view and a filter view?

Excel’s custom views store more than filters—they include column widths, hidden rows, print settings, and zoom. Google Sheets’ filter views only store filter criteria and sort order. If you need to save column widths or print settings in Google Sheets, you would need to use separate sheet tabs or add-ons, as there is no built-in equivalent.

Related

• Budget 5G Phone India: What to Check First
• Save Highlighted Text in Firefox to a File
• Airplane Mode on Phone: What It Does & When to Use It