If you want to create a named range in Excel, you can select the range and type the name you choose in the name box on the top left side of the worksheet, next to the formula bar, or you can use this shortcut:
Work faster in Excel with shortcuts!
If you want to create a named range in Excel, you can select the range and type the name you choose in the name box on the top left side of the worksheet, next to the formula bar, or you can use this shortcut: