Define name using row and column

Creates range names automatically based on the row and column labels around your selected data, saving you manual naming effort.

Shortcut Windows Mac
Define name using row and column Ctrl Shift F3 Fn Ctrl Shift F3

Relevant Excel Shortcuts

Discover related Excel keyboard shortcuts in the formula navigation category.

Toggle formulas on and off
Expand or collapse formula bar
Toggle absolute and relative references
Define name for references
Open Name Manager
Paste name into formula
Accept function with autocomplete

Download Your Complete Excel Shortcuts Cheat Sheet

Get instant access to a comprehensive PDF guide of all Excel keyboard shortcuts available on our website. Perfect for quick reference and offline use for both Mac and Windows users. Click below to download your copy and boost your productivity today!

Free PDF
PDF guide of all Excel shortcuts for Windows and Mac