Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
How to Use Sheet Name in Excel Formula (Quick Methods)
The term Worksheet used in Excel documents is a collection of cells organized in rows and columns. It is the working surface you interact with to enter data. Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.
At the bottom of each worksheet in the Excel document window is a small tab that indicates the name of the worksheets in the workbook. Excel names these worksheets using a default name. These names (Sheet1, Sheet2, Sheet3, and so on) are not very descriptive; you might want to rename your worksheets to reflect what they contain. For instance, if your workbook contains your annual budget, each worksheet within the workbook might contain budgets for individual months.
Location of Sheet Names
By default, each Excel workbook contains three worksheets named Sheet1, Sheet2, and Sheet 3. Their tabs are at the bottom of the spreadsheet as shown. If you don't see them, make the worksheet shorter vertically.
Rename Excel Sheet name
There are three ways you can rename a worksheet, and the only difference between them is the way in which you start the renaming process. You can do any of the following:
Double-click the worksheet tab and type the new name.
Right-click the sheet tab, click Rename, and type the new name.
Use the keyboard shortcut Alt + H + O + R, and type the a name. (The cursor can be anywhere in the worksheet.).
Get Sheet Name Using the CELL Function
When working with Excel spreadsheets, sometimes you may have a need to get the name of the worksheet. While you can always manually enter the sheet name, it won’t update in case the sheet name is changed. So if you want to get the sheet name, so that it automatically updates when the name is changed, you can use a simple formula in Excel.
=RIGHT(CELL(filename),LEN(CELL(filename))-FIND(],CELL(filename)))
How to pull data from another sheet by using cell references in Excel using sheet name:
Click in the cell where you want the pulled data to appear.
Type =(equals sign) followed by the name of the sheet you want to pull data from. If the name of the sheet is more than one word, enclose the sheet name in single quotes.
Type! followed by the cell reference of the cell you want to pull.
-
Press Enter.
5.The value from your other sheet will now appear in the cell
If you want to pull across more values, select the cell and hold the small square in the bottom-right corner of the cell
Drag down to fill the remaining cell
Did you learn about how to change Legend Name in Excel Spreadsheets? To be office excel
Did you learn how use sheet name in excel. You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets and PowerPoint Slides.
You can also download WPS Office to edit the word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.
Also Read:
- 1. How to Change Sheet Name in Excel Sheet with Shortcut
- 2. Name Box: How to add table name in Excel
- 3. Name Manager: A Quick Way to Name a Cell in Excel
- 4. How to find sheet name by Formula in Excel (3 methods)
- 5. How to make First Name and Last Name in Excel Using Formula
- 6. How to make Excel Formula Sheet Name in Excel