Excel Forum
Similar Content
Absolute and Relative Cell References in Excel
Tutorial: In this tutorial I am going to cover the difference between Absolute and Relative Cell Ref...
Calculate Percent Change in Excel
Tutorial: How to calculate the percentage amount that a value has changed in Excel. This includes q...
Prevent Duplicate Values in Excel
Tutorial: I show you how to prevent duplicate values being entered into Excel using Data Validation...



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





Got a Question? Ask it Here in the Forum.