Do you ever have those days where you spend hours agonizing over an excel spreadsheet, wishing there were ways to make the whole process easier and more efficient?

Lucky for you, excel is a powerful platform and there are plenty of creative ways to make it work for you more effectively. Here’s a little known trick that allows you to create dynamic named ranges in excel. These ranges contract and expand according to the data in them, saving you a ton of time and effort when you’re using Excel.

Watch this video and learn how to create dynamic named ranges! Even though it’s a ridiculously easy hack to set up, it’s probably one of the most underutilized aspects of Excel so if you like the video, be sure to share it with your friends and coworkers!

Featured photo credit: Sara Silverstein via

Love this video?