Navigation pane in Excel

This article is also available in: Bahasa Malaysia Bahasa Indonesia


Do you have multiple worksheets in an Excel workbook, and find it hard to move to or select the one that you are looking for?

While you can use the navigation buttons found on the status bar at the bottom left of the workbook, this can be tedious if you have a lot of worksheets to scroll through.

excel worksheet navigation

Using Excel’s navigation pane to move around and manage the worksheets is much simpler.

Accessing the navigation pane

With your Workbook open, click on View, then Navigation.

excel navigation pane menu

The navigation pane will display on the right.

excel navigation pane

You will see a list of all the worksheets in the workbook, much like a table of contents.

In the navigation pane, you can move to a worksheet by clicking on it’s name.

Renaming, deleting or hiding worksheets

In the navigation pane, if you right click on a worksheet, you will be able to rename, delete or hide the worksheet.

excel navigation pane context menu
excel navigation pane rename worksheet

Searching

You can also search for a particular worksheet, or search in all worksheets from the navigation pane.

excel navigation pane search

This includes searching for tables and charts.



Did you find this article helpful? Please rate and also share your thoughts in the comments section below.

0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments

Status Bar in Excel

Status Bar

Using wild cards in Excel

Wild cards



This article is also available in: Bahasa Malaysia Bahasa Indonesia