Exceljet

Quick, clean, and to the point

Define name using row and column labels

Windows shortcut 
CtrlShiftF3
Mac shortcut 
FnF3

This shortcut displays the Create Names dialog box, which can be used to automatically name ranges based on row and column headings.

Sir your website is awesome. It gave me what I want. Thanks and hope it will help me again when I need it - Atul
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course