SECRET Excel Named Range Shortcuts to Save Time

0:00 Introduction
0:21 Types of Defined Names
0:37 Defining Named Cells
1:37 Defining Named Ranges
2:07 Defining Names from Tables
2:56 Defining Named Constants
4:07 Defining Named Formulas
5:42 Defined Name Scope
8:53 Defined Name Shortcut

[bonjovm]

Hi Mynda, I thank God for people like you, thanks very much for your contents, God bless you always !

[patrick.schommer]

I had never given much thought to scope when working with named ranges. I appreciate your clear explanation with examples. That last bit using "=!B2" was fantastic!

[AdvisorsDesk]

Your excel teaching is better than anyone ❤

[pbs]

It seems there's always something more to learn about Excel Names.
I just realized that storing a formula in a name is very useful to reuse it around the workbook (with all the advantages that it represents in terms of maintaining the formulas), but also not lose the formula in case we delete all the cells that contained it. It's like a UDF without VBA code.

[jmklei]

I have been using defined names quite a bit lately and it is such a great tool. But, there is always something to learn. There were certainly some good tidbits in here. Thank you.

[rodneyplunkett]

Even the videos you think are beginner or intermediate I find useful. I am always picking something up. Thank you!

[bobmoorehead]

I always love the handy shortcuts you share! Such time savers. Thank you so much!

[pixelmasque]

eloquent explanation of the different paths of name creation. didnt know you could create a variable name without first choosing a cell with value, sweet !!

[corynardin]

Thank you for covering name scope. So many videos cover just naming a cell or range, but hard to find one that covers everything! Super simple and easy to follow along. Cheers.

[cybu]

Love it! Great trick for this "=!A1". Thank you!

[henryg]

Thank you Mynda. It's good to be reminded, especially as I clearly don't use defined names enough. But the thought of models using Named Constants fills me with dread!

[johnmccormick]

I’ve been somewhat confused by names in Excel for years… great explanation!

[girishpadshala]

Thanks Mynda, I always learn something new from your channel. At last in this video, Removing sheet name infront of ! in formula and using Same Name Range with different values as per different sheets was great idea.

[GrainneDuggan_Excel]

Very clear explanation. Thanks for the solution to copying worksheet and creating duplicate names. Very helpful. Thanks Mynda

[chrism]

Very clear Mynda. I knew how to do this, but usually forget to do so in my day to day work. Thanks!

[madlarch]

Wow - I just chanced across your channel today, and that little tip about just using the "!" in front of a name is priceless! A while ago I was adding some sheets to a workbook that used a lot of names, and ran into many issues with them. This at least solves one of them. The other big issue I had was that if I copied one of my worksheets to another workbook it had a tendency to drag along all of the names from the original workbook as well. I ended up writing some macros to clear them out, but it was a right pain, and made me cautious about using names since then. Maybe I will give them another chance, especially since I recently upgraded from Excel 2013 to MS 365, and am now starting to learn about much of the very useful new functionality it provides.

Many thanks for your videos. I have subscribed, and will be watching a lot more of them!

[coquiboricua]

Very helpful and thorough. Helped me through my college project. Thank you!❤

[lchase]

Thank you for another great video. I needed this a few days ago so i came to your channel. Helpful and clear as always.
Ty

[goldendice]

Thanks a lot. Your videos are always a great help to optimize my job☺️

[vijayarjunwadkar]

Very useful video! Thanks Mynda for some cool tips on named ranges, which are going to help a lot! 😊👍