How to Turn Off Sheet View in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

If you are looking for how to turn off Sheet View in Excel, then you are in the right place. In our practical life, we often need to work with Excel sheet views to filter specific databases and use them within one sheet in an effective way. And again, we need to turn off the sheet view for specific reasons. In this article we’ll try to discuss how to turn off sheet view in Excel.


How to Turn Off Sheet View in Excel: 2 Steps

Excel offers some easy steps to turn off the sheet view. To show this, we have prepared a dataset named Dataset to Turn Off Sheet View which has column headers as Branch Name, Sales Rep, Product Name and Sales.

turn off sheet view in excel

We’ll now discuss how to turn off sheet view.


Step-01: Activating Sheet View 

To understand the steps of turning off the sheet view, firstly, we need to activate the Sheet View. Activating sheet view is another topic of interest. Here, the dataset we are dealing with is activated already which we can understand by seeing the following things.

  • AutoSave is turned On.
  • New option is available in the Sheet View box under View.
  • Columns and Rows are marked with black color.

turn off sheet view in excel, activate sheet view


Step-02: Using Sheet View Option to Turn Off Sheet View

In this step we’ll see how to turn off sheet view. To show this, we have made a dataset where we can see the turn on of the sheet view. In the following database of Turn Off Sheet View we have filtered Branch 1 from the Branch Name header and also we have filtered the Sales in descending manner. We can understand this by seeing the filter icon in these two column headers. The dataset is like this.

turn off sheet view in excel

Suppose we want to turn off this sheet view.

  • Firstly, go to View > click Exit from Sheet View box.

turn off sheet view in excel

  • Immediately, we’ll see that the sheet view has turned off and Default view has appeared. 

We’ll understand this by watching the removal of black color of Columns and Rows.

turn off sheet view in excel


How to Switch Between Sheet Views

We can switch between sheet views very easily. We need to work on the following dataset to show this.

turn off sheet view in excel, switch sheet view

  • Firstly, go to View. We’ll see from the Sheet View box that the current sheet view is of Sales in Descending Manner.
  • Secondly, click on the icon of the sheet view name.
  • Thirdly, choose any option from there. We have selected Sales in Branch 1 i.e. we want to switch from Sales in Descending Manner to Sales in Branch 1.

turn off sheet view in excel, switch sheet view

Consequently, we’ll see that the sheet view is switched to Sales in Branch 1.

turn off sheet view in excel, switch sheet view


How to Delete Sheet View

We can permanently delete a sheet view easily. We’ll work on the following dataset to show this. Here, in this dataset we can see that the sheet view is for Sales in Branch 1. We want to delete this sheet view.

turn off sheet view in excel, delete sheet view

  • Firstly, go to View > select Options.

delete

Eventually, a Sheet View Option window will appear.

  • Secondly, choose Sales in Branch 1 > press Delete.

delete

Consequently, a window of Delete this sheet view? will appear.

  • Thirdly, press Delete.

delete

  • Fourthly, the Sheet View Options window will appear. Click the cross mark.

delete

Finally, we’ll see that the sheet view of Sales in Branch 1 has been deleted. We will understand this if we go to View, then we’ll not see any Sales in Branch 1 option in the Sheet View box.

delete


Download Practice Workbook


Conclusion

We can turn off the sheet view very efficiently if we study this article properly. We can also get an effective knowledge of the ways of activating sheet view or switching sheet view by studying this. Please feel free to visit our official Excel learning platform ExcelDemy for further query.


Related Articles

Shajratul Alam Towhid
Shajratul Alam Towhid

Hello, myself Shajratul Alam Towhid. Basically, I am a Naval Architect who wants to expand knowledge in the field of Microsoft Excel. I wish all of my articles will be beneficial for the readers.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo