Paste Name Into Formula

Using the Paste Name Into Formula Shortcut

Windows keyboard shortcut

 
Mac keyboard shortcut

This Excel shortcut allows you to paste a previously defined name into a formula and displays the Paste Name dialog box.

While Mac doesn't have a similar shortcut you can still use Insert > Name > Paste from the menu.
Other useful Formula keyboard shortcuts