Скачать с ютуб Create Dynamic Named Ranges in Excel Across Rows Going Up/Down в хорошем качестве

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!