Akehgmr

 Excel name types In Microsoft Excel, you can create and use two types of names Defined name a name that refers to a single cell, range of cells, constant value, or formula For example, when you define a name for a range of cells, it's called aExcel can create names automatically (ctrl shift F3) If you have well structured data with labels, you can have Excel create named ranges for you Just select the data, along with the labels, and use the "Create from Selection" command on the Formulas tab of the ribbon You can also use the keyboard shortcut control shift F3 Shortcut Description In Windows, this shortcut will display the name manager dialog box, where you can click the new button to create a new name In MAC, this shortcut displays define name dialog box To do this, you need to press (CTRL F3) keys to display the name manager dialog box Excel Named Range Shortcut My Online Training Hub Define name shortcut excel mac