THE Ultimate  Excel Portal     [ Popular | New | Editor's Picks | Top Rated ]
Home >> Excel Tutorials >> Named Ranges

Named Ranges

:: 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.




Links in This Category: 3
   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.
Rating: (0 votes) - Details - Added: 06-02-2004 - Hits: 2442 - Error?

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.
Rating: (1 votes) - Details - Added: 05-12-2006 - Hits: 1953 - Error?

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.
Rating: (1 votes) - Details - Added: 05-12-2006 - Hits: 1549 - Error?

 
Main Categories
Excel Add-ins
Excel Help
Excel Password Recovery
Excel Templates
Excel Tips & Tricks
Excel Tutorials
Excel VBA
Free Excel Add Ins
Spreadsheet Research
Create Excel Dashboard Reports with Plug-N-Play Reports
Newest Links
Vertex42 Money Manager
Kaizen Excel Templates
Learn Excel VBA Easily
Employee Payroll Spreadsheet
Viral Growth Forecaster
Excel Training Guides
The Formulator
Financial Modeling Training Program
Customer Invoicing Template
Personal Debt Analyser



Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation. This site is in no way associated with Microsoft.