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

http://www.TeachMsOffice.com

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.


To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachExcel.com You can also visit the forum there if you have any questions.

Have a great day!

Category:

Education

Tags:

• microsoft
• excel
• office
• 2003
• 2007
• help
• tips
• tricks
• dynamic
• named
• ranges
• between
• across
• rows
• going
• up
• and
• down

[mikelsok]

I like your videos very good, one question in this example,surely you could just put a formula in cell E2 like =sum(B2:B1000) and that would still give the same answer wouldn't it?

[ExcelisHell]

@mikelsok Yea. But, this example was just to show you how to make dynamic references, which in some cases are very helpful.