Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Retrofitting A Worksheet With Defined Names

K2 Enterprises
5.09K subscribers
458 views 12 years ago
Defined names serve many useful purposes in Excel, including creating self-documenting formulas. However, if you have already created your workbook with traditional row and column addresses, manually editing all of your formulas to replace the row and column references to defined names could be a daunting task. In this tip, you will learn how to retrofit your formulas to use defined names instead of row and column addresses. ...more
...more
Retrofitting A Worksheet With Defined Names
1Likes
458Views
2013Feb 27
Defined names serve many useful purposes in Excel, including creating self-documenting formulas. However, if you have already created your workbook with traditional row and column addresses, manually editing all of your formulas to replace the row and column references to defined names could be a daunting task. In this tip, you will learn how to retrofit your formulas to use defined names instead of row and column addresses.

Follow along using the transcript.

K2 Enterprises

5.09K subscribers