Excel Forum
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




Create Dynamic Named Ranges in Excel Across Rows Going Up/Down


This is a great tutorial which shows you how to make a named range within Excel dynamic. This specific Excel tutorial will explain how to make a dynamic named range across multiple rows going up and down. This is a great technique to use so that whenever you update or change a list to make it bigger or smaller, and named ranges refer to this list, the ranges will automatically update. This will save you a lot of time when working with large spreadsheets or just any spreadsheet, which uses named ranges, and is updated often.

This tutorial shows you how to make a dynamic named range which goes up and down across rows within Excel.
   Topics Covered
Create Dynamic Named Ranges in Excel Across Multiple Rows (Up/Down)
Automatically Update Named Ranges in Excel
Edit Named Ranges in Excel
   Difficulty:         Intermediate
   Video:               Yes



Got a Question? Ask it Here in the Forum.