How to Turn Off Temporary View In Excel

  • Home
  • / How to Turn Off Temporary View In Excel
How to Turn Off Temporary View In Excel

Turning off the temporary view in Excel is an essential skill for users who need to manage their worksheets effectively without the distraction of temporary settings.This comprehensive guide will walk you through the process of how to turn off temporary view in excel, explain its significance, and ensure you have all the necessary knowledge to handle this task efficiently.

Understanding Temporary Views in Excel

Temporary views in Excel can refer to several features such as filter views, custom views, or even the display settings that users might adjust temporarily for better data visualization or analysis.These temporary adjustments are meant to help users interact with their data more efficiently, but sometimes they can lead to confusion or clutter in the worksheet.Turning off or resetting these views can restore the worksheet to its default state, making it easier to manage and analyze data.

Significance of Turning Off Temporary Views

  1. Clarity:

Temporary views can sometimes hide important data or make it difficult to see the full picture. Turning them off can provide a clearer view of the entire worksheet.

  1. Data Integrity:

When sharing worksheets with others, temporary views might not convey the intended message. Disabling them ensures that everyone sees the same data presentation.

  1. Performance:

Some temporary views or filters can slow down the performance of large worksheets. Turning them off can enhance the speed and responsiveness of Excel.

  1. Simplification:

For those who are not familiar with the temporary settings, it can simplify the user interface and reduce the learning curve.

How to Turn Off Temporary Views in Excel

  1. Turning Off Filter Views

Filters are one of the most commonly used temporary views in Excel. They allow users to display only the rows that meet certain criteria, hiding the rest.

Step-by-Step Process:

  1. Open Your Worksheet:

Start by opening the Excel worksheet that has filters applied.

  1. Go to the Data Tab:

Click on the ‘Data’ tab in the Excel ribbon.

  1. Clear Filters:

   If you want to clear filters from all columns, click on the ‘Clear’ button in the ‘Sort & Filter’ group.

   If you want to clear a filter from a specific column, click on the filter drop-down arrow in that column and select ‘Clear Filter from [Column Name]’.

  1. Disabling Custom Views

Custom views in Excel allow you to save different display settings and print settings. Sometimes, you might want to revert to the original view.

Step-by-Step Process:

  1. Open Your Worksheet:

Start by opening the Excel worksheet that has custom views applied.

  1. Go to the View Tab:

Click on the ‘View’ tab in the Excel ribbon.

  1. Custom Views:

Click on ‘Custom Views’ in the ‘Workbook Views’ group. A dialog box will appear listing all the saved views.

  1. Show Default View:

Select the view named ‘Default’ (or the view you want to revert to) and click ‘Show’. If no default view exists, you may need to manually adjust the settings back to your preference.

  1. Resetting Display Settings

Temporary display settings can include zoom levels, pane freezes, or conditional formatting that temporarily change the look of your worksheet.

Step-by-Step Process:

  1. Zoom Level:

   Zoom to 100%: Go to the ‘View’ tab, and in the ‘Zoom’ group, click on ‘100%’ to reset the zoom level.

  1. Unfreeze Panes:


Go to the ‘View’ tab, in the ‘Window’ group, click on ‘Freeze Panes’, and select ‘Unfreeze Panes’ if panes are frozen.

  1. Clear Conditional Formatting:

   Clear Rules:

Go to the ‘Home’ tab, in the ‘Styles’ group, click on ‘Conditional Formatting’, and choose ‘Clear Rules’ > ‘Clear Rules from Entire Sheet’ to remove temporary formatting.

  1. TurningOff Worksheet Protection Views

If your worksheet is protected with specific views enabled for different users, you might need to turn off these settings.

Step-by-Step Process:

  1. Open Your Worksheet:

Open the worksheet with protection enabled.

  1. Go to the Review Tab:

Click on the ‘Review’ tab in the Excel ribbon.

  1. Unprotect Sheet:

Click on ‘Unprotect Sheet’ in the ‘Changes’ group. You might need to enter a password if the sheet is password-protected.

  1. Adjust Settings:

Once unprotected, you can adjust any temporary views or settings as needed.


  • Managing temporary views in Excel is crucial for maintaining a clear, efficient, and collaborative workspace. Whether you are dealing with filters, custom views, display settings, or protection views, knowing how to turn off these temporary settings can significantly enhance your productivity and data accuracy.
  • By following the step-by-step processes outlined above on how to turn off temporary view in excel, you can ensure that your Excel worksheets are always presented in their best possible state, free from unnecessary distractions and temporary configurations.
  • These skills not only improve your immediate work environment but also prepare you for more advanced data management and analysis tasks in Excel. Understanding and controlling the way data is viewed and presented is fundamental to effective data manipulation and presentation.

Write your comment Here