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...
Calculate Hours Worked - Day or Night Shift & Breaks in Excel
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.