How to create dynamic named range in Excel. Learn 2 easy ways to create dynamic named range of both one and two dimensional in Excel.