The Name Box in Excel - Excel A to Z Series

[@zinebadaika6544]

I've been looking for it for a while till I came across your channel...May Allah bless u.

[@EricHartwigExcelConsulting]

Great information Gasper! Thank you for creating this video I can not wait to apply this information!

[@ExcelOlympics]

Thanks. Glad to hear that!

[@wayneedmondson1065]

Hi Gasper. Great walk through of all the features of Name Box! Very useful. Thanks for demonstrating. Thumbs up!!

[@ExcelOlympics]

Thanks Wayne.

[@cyclingtraveler2595]

Hi, Thank you for your excellent tutorial.

[@ExcelOlympics]

Thanks and happy travels :)

[@martyc5674]

Hi Gasper- great video, I didn’t know about holding down shift/ctrl to extend selected ranges 👍 A trick I learned recently was that you can put a formula directly into the name box. Eg an Xlookup(without the = )… and it will bring you to the cell that contains the result. Something that is missing from name box also are dynamic named ranges, they are not in the drop down list but if you know the names and type them into the name box then the dynamic range will be highlighted.

[@ExcelOlympics]

Hi Martin. Yes, it is a shame about the dynamic named ranges. I Love the Xlookup trick. Thanks for sharing!

[@ExcelMoments]

Good comments Martin. Since XLOOKUP returns a reference/range, it works. It has always worked with the INDEX and OFFSET functions too. Nice add

[@ronaldpalmgren9478]

very instructive video. I saw a you tube tutorial where the speaker used the name box to highlight column but it also showes the number of inches that column. do you know how that was done?

[@rllove03]

Definitely learned some things. But can you give an example on being able to scroll through sheets in the name box?

[@ExcelMoments]

Who does a 15-minute video on the "irrelevant" name box? Gasper 😁😁. Excellent video

[@ExcelOlympics]

I could have gone longer 😀

[@HJay]

Can the name box work in the other direction i.e., if you select a cell can you capture the selected cell and maybe include the cell reference in a formula?

[@kamranahmadov8703]

Hi. Thank you for sharing your knowledge all about you know. You are a really really well trained man. I loved your method and knowledge. However, I scrolled down your video list and unfortunately there are not a lot of video about excel. Can I kindly ask you to continue like this? Many thanks beforehand. Or, do you have an excel book from A to Z and is it on sale?

[@ExcelOlympics]

Hi Kamran. First of all, I want to thank you for those kind words! They do mean a lot to me. There were some issues that required my attention and I therefore hadn't posted any new content, but more is definitely coming... PS: the only book I'm featured in is Excel Insights - www.mrexcel.com/products/excel-insights/

[@paulvanobberghen]

Hello. At 15:18 you make a selection and then move from cell to cell inside that selection. That's cool but how do you do that? Can't seem to find out how. Thanks in advance.

[@ExcelOlympics]

Hi Paul. I think it's just a regular old Enter, Shift + Enter and Tab and Shift + Tab :)

[@pepitotaloloto8685]

Sir can you insert a symbol like beta in the name box?

[@teoxengineer]

And, There is one more thing regarding names that intersection propertiy. If we create names both rows and columns then we can find intersect of them like = 1:4 K:L (K1:L4). It happens thanks to gap operator between ranges ;) Besides, if we define names from selection icon, you don't need to use index and match or VLookUp or XLookUp formulas. Just use names with gap and find intersection ...bamm :)

[@tutsecret499]

Speaking of million rows. How the Tax Dept handle million, billion people in their database for tax. I mean, how possibly using excel, if taxpayer might be exceed the limit of the rows of excel. So they would use a different software bigger than Excel?

[@ExcelOlympics]

Very likely but not for that reason as you can get around that limit with Power Pivot and also with Power Query.

[@bideneleyla972]

🎉