Excel pro tips: How to create, define, and use Named Ranges

Working with ranges in Excel is a fast and simple way to identify, define, or refer to a single cell, a range (or group) of cells, a specific or constant value, or a formula. Then you can use those range names in your formulas or macros to replace values or cell references, or to quickly and more easily navigate through your spreadsheets and workbooks. It’s also a more efficient way to manage the various processes that you’ve created in your worksheets. For example, ranges are often named after the field (or column) names that define their contents. Check out this tips from PCWorld.com