“Ctrl + Shift + F3” keys are used to “create names” for a row or column from the labels of columns and rows. You can create the names for the selected cell or cells from the values of the top row, bottom row, left column, or right column. Once you click Ctrl + Shift + F3, a dialog box will appear asking you to select the option on the basis of which you wan to create the named ranges.
Note – If this function is not accessible in your system use – Ctrl+Shift+Fn+F3
