You are browsing Vertex42's directory of Excel websites and resources. Browse Vertex42's Excel Templates
Named Ranges
Links in This Category: 3
:: Named ranges can enhance worksheets, making formulas easier to interpret and making macros more flexible.
:: What is a named range in Excel? - Select a cell or group of cells. Then press Ctrl+F3 or go to Insert > Name > Define .... You can then use the name in place of the cell reference in your formulas and macros.
:: What is a named range in Excel? - Select a cell or group of cells. Then press Ctrl+F3 or go to Insert > Name > Define .... You can then use the name in place of the cell reference in your formulas and macros.
| Performance Analysis using Named Ranges www.grbps.com | |
| Analysing performance data in Excel using array formula and dynamic range name methods. This is an interesting article on how to use named ranges effectively. | |
|
Added: 06-02-2004 - Updated: 06-03-2004 - Hits total: 2686
| |
| Dynamic Named Ranges | |
| Possibly one of Excels most underutilized aspects is its ability to create dynamic named ranges that will expand and contract according to the data in them. Here are 7 different types of these ranges. | |
|
Added: 05-12-2006 - Updated: - - Hits total: 2224
| |
| Excel Named Ranges OzGrid.com | |
| Named Ranges in Excel have been around a long time. Using them frequently is a very good habit to form. Find out more at OzGrid.com. | |
|
Added: 05-12-2006 - Updated: - - Hits total: 1810
| |