Excel Sheet Name Archives

How to Search by Sheet Name in Excel Workbook (2 Handy Methods)

Jun 18, 2024

Method 1 - Right-click the Navigation Button The Navigation button can be found just above the Status bar. In an Excel workbook containing ...

How to Search by Sheet Name in Excel Workbook (2 Handy Methods)

How to Apply Sheet Name Code in Footer in Excel (3 Ways)

Nov 11, 2025

Header and footer options are mostly used when we want to print our Excel document. We will guide you through several methods for the Excel sheet ...

How to Apply Sheet Name Code in Footer in Excel (3 Ways)

How to Use Sheet Name Code in Excel (4 Applications)

Nov 11, 2025

In this article, we will learn how to use and get sheet name code in Excel. In Microsoft Excel, we can use the sheet name directly in a formula as a ...

How to Use Sheet Name Code in Excel (4 Applications)

How to Get the Sheet Name in Excel (2 Methods)

Jul 10, 2024

Method 1 - Using Excel Formula Excel lacks a built-in function to directly retrieve the sheet name, but we can create a formula using the MID, ...

How to Get the Sheet Name in Excel (2 Methods)

How to List Sheet Name in Excel (5 Methods + VBA)

Jul 8, 2024

In this article, we'll discuss various ways to derive a list of sheet names in Excel. Unfortunately, there is no dedicated function to fetch a list ...

How to List Sheet Name in Excel (5 Methods + VBA)

How to Rename Sheet in Excel (6 Suitable Ways)

Nov 11, 2025

While working in Excel, often we have to rename a sheet. Properly named and organized worksheets are important for the look of the spreadsheet. In ...

How to Rename Sheet in Excel (6 Suitable Ways)

How to Insert Excel Sheet Name from Cell Value (3 Easy Ways)

Jul 3, 2024

Method 1 - Combining MID, CELL, and FIND Functions to Insert the Sheet Name into Cell Value Consider the following dataset. We want to insert the ...