How to Use Sheet View in Excel (with Simple Steps)

Get FREE Advanced Excel Exercises with Solutions!

If you are looking for how to use 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. In this article, we’ll try to discuss how to use sheet view in Excel.


Download Practice Workbook


4 Steps to Use Sheet View in Excel

Excel offers some easy steps to use sheet view in Excel. To use this, we have made a dataset to use the Sheet View ribbon. It has column headers such as Branch Name, Sales Rep, Product Name, and Sales. The dataset looks like this.

how to use sheet view in Excel

Let’s see how we can use Sheet View.


Step-01: Activate Sheet View to Use Sheet View in Excel

We have to activate Sheet View by saving the Excel sheet in Sharepoint or One Drive. It is possible when Microsoft 365 is activated.

Here we are using Microsoft 365 i.e. it is activated.

how to use sheet view in Excel, activating sheet view

Eventually, a bar named How do I Turn on AutoSave will appear.

  • Secondly, select AutoSave – Personal.

how to use sheet view in Excel, activating sheet view

Consequently, the AutoSave option is turned on now.

how to use sheet view in Excel, activating sheet view

Read More: How to Create Different Views for Different Users in Excel


Step-02: Create a Temporary View to Use Sheet View in Excel

We need to create a Temporary View before creating any specific sheet view.

  • To do this, go to View > click the eye-marked icon in the Sheet View

how to use sheet view in Excel, Creating Temporary view sheet view

Consequently, a Temporary View is added. We can understand it by looking at the black color of the columns and rows.

how to use sheet view in Excel, Creating Temporary view sheet view

Read More: What Is Datasheet View in Excel?


Step-03: Filtering and Creating New Sheet to Use Sheet View in Excel

We can filter and create new sheets in the sheet view. To do this, we need to work on the following dataset of Filtering and Creating New Sheet.

  • More importantly, to bring up the Filter option, click CTRL + SHIFT + L. Consequently, drop-down arrows will be added like in the picture shown below.

how to use sheet view in Excel, filtering and creating new sheet

Now, suppose we want to reorder Sales in descending value.

  • Firstly, select the Filter option icon in the Sales
  • Secondly, choose Sort Largest to Smallest.
  • Thirdly, click OK.

how to use sheet view in Excel, filtering and creating new sheet

Consequently, we’ll see that the Sales values are reordered in descending order and the icon of the Sales column is changed which actually indicates that this column is sorted.

  • Fourthly, change the title name to Sales According to Descending Value.

how to use sheet view in Excel, filtering and creating new sheet

Additionally, suppose we want to make a sheet of Sales in Branch 1 only.

  • Again, click New from the Sheet View

 filtering and creating new sheet

  • Secondly, select the filter option icon in the Branch Name
  • Thirdly, select Branch 1.
  • Fourthly, click OK.

filtering and creating new sheet

Eventually, a new sheet will appear.

  • Fifthly, change the title name to Sales in Branch 1.

 filtering and creating new sheet

Read More: What Is Page Layout View in Excel? (Detailed Analysis)


Step-04: Work on Sheet View Option to Use Sheet View in Excel

We can Rename, Make Duplicate or Delete any sheet by using Options from the Sheet View box.

  • Firstly, to use these options click Options.

work in Options

Eventually, a Sheet View Options window will appear.

  • To Rename the sheet of Sales According to Descending Value, click the sheet first and then click Rename.

work in Options

Eventually, a Rename Sheet View will appear.

  • Change the name to Sales.

work in Options

Let’s say we want to Duplicate the sheet of Sales.

  • Pick the sheet of Sales.
  • Secondly, select Duplicate.

work in Options

Consequently, we actually have created Sales (2) as a duplicate sheet of Sales.

work in Options

Similarly, we can delete any sheet in the sheet view by selecting Delete in the Sheet View Option.

Read More: Remove Unused Cells in Excel (8 Easy Ways)


Things to Remember

  • When we turn off the AutoSave option, we actually don’t activate the option New in the Sheet View, which we can understand by seeing the blurred condition of the New.
  • When we add a new sheet in the sheet view, we can understand it by seeing the black background of the columns and rows.

Conclusion

We can use sheet view in various ways if we study this article properly. Please feel free to visit our official Excel learning platform, ExcelDemy, for further queries.


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