Mehedi Hasan Shimul
Finding your way around Excel workbook has become quite more accessible after the introduction of Navigation Pane. With the help of Navigation Pane, we can find different elements of the workbook easily. Also, it’s possible to perform different actions on those elements. In this article, we will show 3 handy applications of Navigation Pane in Excel.
Download Practice Workbook
You can download the practice workbook from here.
The navigation pane in Excel is a useful tool that shows all the elements included in a workbook. Though the main purpose is easy accessibility, using it we can do different actions to the elements of the workbook like renaming sheets or deleting sheets. Also, different actions can be done on all the elements that are in the workbook. We can open the navigation pane from the pane.
- Firstly, go to the View tab of Excel ribbon and select Navigation.
- As a result, we will see the Navigation pane on the right side of the worksheet.
Navigation pane has different applications with worksheets and their elements. Here, we will discuss 3 handy applications of the navigation pane. For demonstration purposes, we have used a few worksheets that have elements like tables, pictures and charts.
The primary function of the navigation pane is the easy accessibility of the worksheets and their elements. In this section, we will show the stepwise procedures to find your way around the workbook using the navigation pane.
- Firstly, you can select any of the worksheet names from the navigation pane.
- As a result, you will see different elements of that worksheet displayed in the navigation pane.
- For example, we have selected Sheet1 > Chart 1 and it takes us to the chart of the worksheet.
- Also, we selected range B4:C9 of Sheet1.
- Consecutively, it selects that range of worksheet Sheet1.
- Similarly, we selected the Header of Sheet2.
- Instantly, it takes us to the Header of Sheet2.
Read More: How to Navigate Between Sheets in Excel (8 Easy Methods)
Some general actions like Renaming, Delete or Hide sheet can be done with help of the navigation pane. In this section, we will show the stepwise procedures to perform those general actions using the navigation pane.
- Firstly, right–click on a sheet name.
- Then, select Rename from the options.
- Afterward, in the rename to box write the new name and press OK.
- Finally, we changed the sheet name using the navigation pane.
- On the other hand, we can also hide a sheet in a sort of similar way.
- Again, right–click on a sheet name.
- After that, select Hide.
- Now, the sheet name with its content is greyed out.
- Also, we won’t find the sheet in the sheet tab.
- Further, right-click on the hidden sheet (greyed-out sheet).
- Consecutively, click on Show.
- As a result, the hidden sheet will be displayed again.
Note: We can also delete any sheet following similar steps. All you have to do is select Delete instead of Rename or Hide.
Read More: How to Perform Cell Navigation in Excel (4 Easy Ways)
Another application of the navigation pane is to search different elements of a workbook. In this section, we will discuss the stepwise procedures to search different elements like charts, tables, or pictures from different worksheets of a workbook.
- Firstly, write the name of the element in the search box of the navigation pane. We wrote Picture.
- Instantly, the picture from any worksheet will be displayed.
- Further, select that Picture from the list and it will take us to that picture in the worksheet.
- Again, write table in the search box.
- As a result, tables from the workbook will appear in the pane.
- Further, select the desired table from the list in the navigation pane.
- Finally, it will take us to the Table in the workbook.
Conclusion
In this article, we discussed various applications of the Navigation Pane. If you have any queries or suggestions, let us know in the comment section. Visit our ExcelDemy Website for similar articles regarding Excel.
