Excel Name Trick 8: Names Relative Cell Reference for Sheet
See how to Name cell ranges with Relative Cell References instead of the default Absolute Cell References. Use the Name Manager (2007) or Define Name (2003 dialog box to edit your named ranges. This is a logical (beginning to end) story about most of the use for Excel Names. In this series you will see 12 amazing uses for Excel Names (14 total Name Tricks).