You can also force Excel to name a range based on data you already have in your worksheet. Select the range you want to name, and in the Formulas tab on the ribbon, click "Create From Selection." ...

Go to the area of the navigation button on the left and right-click between them. An Activate Sheet dialog box will open. We can use the Name box in the top left of the spreadsheet in Excel.

Renaming Excel worksheets supports navigation, organization, and cross-sheet references. Descriptive sheet names aid accessibility by helping those using screen readers to navigate the workbook.