How to (Navigation Pane) List Sheets, Workbooks, Columns, Names, and Insert Auto Text in Excel?
Tags: kutoolsexceltutorial, navigationpaneoption, kutools
Published: 2020-12-04 10:35:05

---
title: How to (Navigation Pane) List Sheets, Workbooks, Columns, Names, and Insert Auto Text in Excel?
published: true
date: 2020-12-04 08:23:35 UTC
tags: KutoolsExcelTutorial,NavigationPaneOption,Kutools
canonical_url: https://geekexcel.com/how-to-navigation-pane-list-sheets-workbooks-columns-names-and-insert-auto-text-in-excel/
---

In this guide, we are going to see how to **List Sheets, Workbooks, Columns, Names, and Insert Auto Text in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Workbook & Sheet Tab:

In this section, we will see how to list all opened workbooks and their worksheets in the Workbook & Sheet Tab.

![Workbook and Sheet Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-9.png)<figcaption id="caption-attachment-18620">Workbook and Sheet Tab</figcaption>

- On the **Kutools Tab, select** the **Navigation** option**(1)**.
- It will open the **Navigation Pane** where you need to **click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-workbooks-sheets-2.png) **button** to enable the **Workbook & Sheet** pane**(2)**.
- All opened workbooks are listed here. If you want to remove any workbooks, you need to **click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-workbooks-sheets-14.png) **button** to close the workbook**(3)**.
- Then, you can see the following buttons in the opening workbooks section**(4)**.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-workbooks-sheets-4.png) **Sort Workbooks in Ascending Order:** It will sort all opening workbooks in ascending order. If you want to restore it, then press this button again.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-workbooks-sheets-5.png) **Sort Workbooks in Descending Order:** Use this button to sort all opening workbooks in descending order. To recover the original sorting order, you need to press it again.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-workbooks-sheets-6.png) **Workbook Tools:** Click it to quickly access utilities in the workbook group on the Kutools Plus tab.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-name-manager-10.png) **Refresh:** It will refresh the information on the navigation pane.
- All the worksheets of the current workbook are listed here, you can click to navigate between worksheets**(5)**.
- Then, you will see the below-given buttons in the list of worksheets section**(6)**.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-workbooks-sheets-8.png) **Toggle to unhide/hide all hidden worksheet(s):** It will toggle all hidden worksheets to be visible. If you click this button again, it will toggle all visible worksheets to be invisible.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-workbooks-sheets-9.png) **Show hidden sheet(s) in the worksheet pane:** This will toggle all hidden worksheets to be visible in the worksheets pane.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-workbooks-sheets-10.png) **Display protection status of the worksheet in the worksheet pane:** It will mark all protected worksheets. Click again to hide the protection status.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-workbooks-sheets-12.png) **Toggle between two latest sheets button:** To switch between two sheets back and forth.
- You can filter the worksheet by enabling the **Filter function** and entering the sheet name as you need**(7)**.
- Then, you need to **right-click** on any **worksheet name** to display the context menu of worksheets**(8)**.
- At the bottom of the pane, you can see the **total number of all worksheets, visible sheets, and hidden sheets(9).**

## Resource Library Tab:

In the Resource Library Tab, you can save custom formulas, pictures, charts, and so on.

![Resource Library tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/2-9.png)<figcaption id="caption-attachment-18634">Resource Library tab</figcaption>

- First, you need to **click** the **Kutools Tab,** then **select** the **Navigation** option to enable the **Navigation Pane.**
- You need to **click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-autotext-2.png) **button** to open the Resource Library pane**(1)**.
- Then, you can see the group names of the resource library here. You can also create new groups, sub-groups, and delete any group that you don’t need**(2)**.
- The following buttons are given in the list of groups section**(3)**.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-autotext-4.png) **Add group:** Click this button to add a new root group or a subgroup to the currently selected group.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-autotext-5.png) **Rename current resource library group:** You can rename the selected group name.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-name-manager-10.png) **Refresh** : It will refresh the information of the resource library pane.
- To expand this group, click ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-autotext-12.png) before a group name. You can also click ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-autotext-13.png) before a group name to collapse this group**(4)**.
- All the resource library entries of the selected group will be listed here**(5)**.
- you can see the below-given buttons above the list of resource library entries**(6)**.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-autotext-4.png) **Add selected content to Resource Library:** It will add currently selected content to the Resource Library pane.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-autotext-7.png) **Show preview in Resource Library list:** This will display the custom resource library entries in the Resource Library pane.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-autotext-8.png) **Show floating preview of Resource Library entry:** You need to click this button to enable it, and then put the cursor at the resource library entry.
- At last, you can filter the resource library entries by **enabling** the **Filter checkbox** and enter the resource library name as you wish**(7)**.

## Name Manager Tab:

In the Name Manager Tab, you can create a new name range, edit the named range, delete the name range, and so on.

![Name Manager Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/3-8.png)<figcaption id="caption-attachment-18645">Name Manager Tab</figcaption>

- Go to the **Kutools Tab, select** the **Navigation** option to display the Navigation Pane.
- You need to **click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-name-manager-2.png) **button** to open the **Name Manager** pane**(1)**.
- Then, you can see all the range names within the active workbook are listed here**(2)**.
- You can use the following buttons if you need them**(3)**.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-name-manager-4.png) **Create names from the selection:** It is used to create multiple range names based on a row or column labels.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-autotext-4.png) **New name:** It will add a new range name as you need.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-autotext-5.png) **Edit Name:** Use this option to rename the selected range name and change the cell reference of the range name.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-name-manager-7.png) **Delete Name:** It will delete the selected range name as you want.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-name-manager-8.png) **Name Manager:** You can click this button to open the Name Manager Dialog Box.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-workbooks-sheets-8.png) **Display hidden name:** It will display the hidden names.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-name-manager-10.png) **Refresh:** Use this button to refresh the information of the Name ranges.
- You can filter a certain range name by enabling the **Filter function** and enter the range names as you need**(4)**.
- In this **Edit Name** section, you can **rename** the selected range name in the **Name** box. You can also **change the reference** of the range name in the **Refers To** text box.
- Then, you can **click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-name-manager-7.png) **button** to cancel the changes, **click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-name-manager-13.png) **button** to save the changes**(5)**.

## Column List Tab:

The **Column List** pane in the Navigation pane cal list the column names and titles of the current worksheet. Let’s see them below.

![Column List Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/4-8.png)<figcaption id="caption-attachment-18651">Column List Tab</figcaption>

- On the **Kutools Tab, select** the **Navigation** option to enable the Navigation pane.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-column-list-2.png) **Column List tab:** This button is used to enable the column list pane**(1)**.
- In this pane, you will see the list of column titles of the current worksheet**(2)**.
- Use the following buttons if you need**(3)**:
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-column-list-4.png) These arrows can help to move the column up or down.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-workbooks-sheets-8.png) **Toggle to unhide/hide all hidden column(s):** It will toggle all hidden columns to be visible or invisible.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-name-manager-10.png) **Refresh:** It will refresh the information of the column list pane.
- List specific columns in the selected range**(4)**.
- You can also filter the columns by **selecting** the **Filter checkbox** and enter the column name as you need**(5)**.
- Then, you need to **click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-column-list-7.png) **button** to hide the related column in the active sheet and **click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-column-list-8.png) to show the related column in the active sheet**(6)**.

## Advanced Find and Replace Tab:

To find and replace values in multiple worksheets and workbooks, use **Advanced Find and Replace Tab** in Excel.

![Advanced Find and Replace Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/5-7.png)<figcaption id="caption-attachment-18665">Advanced Find and Replace Tab</figcaption>

- On the **Kutools Tab, select** the **navigation** option to enable the **Navigation Pane.**
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-advanced-find-replace-2.png) **Advanced Find and Replace Tab:** It will enable the advanced find and replace pane**(1)**.
- You can **switch** between the **Find** tab and the **Replace** tab**(2)**.
- Here, you can type the search keywords based on your need**(3)**.
- **Specify the finding or replacing scope:** All workbook, Active workbook, Selected sheets, Active sheet, and Selection**(4)**.
- Then, you can **select** all or **unselect** all opening workbooks or worksheets**(5)**.
- **Specify the search direction:** By rows or By columns**(6)**.
- Then, you need to specify the special search scope such as formulas, cell values, comments, hyperlinks, or chart titles**(7)**.
- **Match case –** It will enable the case-sensitive search**(8)**.
- **Match Entire Cell –** You need to select this option if you want to enable an exact search**(9)**.
- **Find All –** click this button to find certain values in the specified searching scope**(10)**.
- Here, you can see the search results or replacement results**(11)**.
- You can **click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-advanced-find-replace-7.png) before a worksheet or workbook to collapse all search results in the worksheet and **click**![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-advanced-find-replace-8.png) **button** to expand all search results in the worksheet or workbook**(12)**.
- ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-name-manager-7.png) **Delete:** It will clear all searching results**(13)**.
- You need to click ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-advanced-find-replace-3.png) to float the Advanced Find and Replace pane in the workspace and click ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-advanced-find-replace-4.png) to collapse the search fields**(14)**.

### Note:

- You can click ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/shot-navigation-options-1.png) button to open the **Navigation Options Dialog Box**.

![Navigation Options Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/6-7.png)<figcaption id="caption-attachment-18669">Navigation Options Dialog Box</figcaption>

- **Show number of worksheets – ** If you check this option, the total number of worksheets, visible worksheets, and hidden worksheets are displayed in the status bar.
- **Using a shortcut key (Win+ Shift + A) to toggle between last two sheets – **It will toggle between the last two sheets.
- **Setting for previews of Resource Library entries – ** This option will preview all text type of resource library entry in a big font.
- **Settings for Name manager – ** If you check this option, the **Name editor** will be displayed in the **Name manager pane.**
- **Apply the Find and Replace pane with shortcuts – ** This will help you to apply the Advanced Find and Replace Function without opening the navigation pane.

## Conclusion:

In the above guide, you can easily understand the steps to **List Sheets, Workbooks, Columns, Names, and Insert Auto Text in Excel Office 365** using **Kutools. ** Don’t forget to share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Merge All Worksheets of Same Name into One Worksheet in Excel 365!](https://geekexcel.com/wp-admin/post.php?post=18549&action=edit)
- [Combine Multiple Worksheets/Ranges into One Worksheet in Excel 365!!](https://geekexcel.com/wp-admin/post.php?post=18519&action=edit)