Rename a worksheet - Microsoft Support
By default, Excel names worksheets Sheet1, Sheet2, Sheet3 and so on, but you can easily rename them. There are multiple ways to rename sheets. However there names cannot be …
Use the Name Manager in Excel - Microsoft Support
Use the Name Manager dialog box to work with all the defined names and table names in a workbook. For example, you may want to find names with errors, confirm the value and …
Group worksheets - Microsoft Support
You can quickly perform tasks on multiple worksheets at the same time by grouping worksheets together. If you group a set of worksheets, any changes you make on one worksheet are …
Why am I seeing the Name Conflict dialog box in Excel?
When you try to move or copy the worksheet, Excel will detect this conflict and display the following message: "The name 'InterestRates' already exists. Select Yes to use that version of …
Insert the current Excel file name, path, or worksheet in a cell
Insert the current file name and the name of the active worksheet. Type or paste the following formula as an array formula to display the current file name and active worksheet name: …
Accessibility best practices with Excel spreadsheets
Screen readers read worksheet names, so make sure those labels are clear and descriptive. Using unique names for worksheets makes it easier to navigate the workbook. By default, …
Insert or delete a worksheet - Microsoft Support
In Excel, you can easily insert, rename, and delete worksheets in your workbook. Select the New Sheet plus icon at the bottom of the workbook. Or, select Home > Insert > Insert Sheet. …
Create a named range from selected cells in a worksheet
You can quickly create a named range by using a selection of cells in the worksheet. Note: Named ranges that are created from selecting cells have a workbook-level scope. Select the …
How to correct a #NAME? error - Microsoft Support
When your formula has a reference to a name not defined in Excel, you see the #NAME? error. See the following example of a SUM function referring to Profit, which is an undefined name in …
Using structured references with Excel tables - Microsoft Support
Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
It's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: …