Define name using row and column labels

Keyboard shortcut options for this action in excel: define name using row and column labels

Windows shortcut 
CtrlShiftF3
Mac shortcut 
FnShiftF3

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

0 votes. 0 / 5