Sign in to confirm you’re not a bot
This helps protect our community. Learn more
The Fastest Way To Create Defined Names In Excel.mp4
110Likes
54,446Views
2012May 28
Defined names (known as "range names" in Lotus 1-2-3) are a long-standing feature in spreadsheets. If we use defined names in lieu of traditional row-and-column addresses, we can create formulas more quickly and easily, while simultaneously creating documentation for our formulas. Yet many Excel users do not use defined names, perhaps because of the time it takes to create them. In this tip, you will learn how to create defined names with just a few clicks of the mouse, thereby removing virtually any reason not to use this great feature of Excel.

Follow along using the transcript.

K2 Enterprises

5.09K subscribers