5 Clever Name Box Tricks in Excel 🤯

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
In this video, I will show you some clever ways you can use the Name Box in Excel. You may already know some of these tricks, but I am sure you will also learn some new ones.
00:00 Video Intro
00:16 Name Box Intro
01:22 Creating Named Ranges
04:56 Go to Any Cell or Range of Cells
09:29 Get the Number of Rows/Columns in the Selected Range
10:14 Go to Specific VBA Code in VB Editor
11:54 Assign Names to Shapes or Charts
Read the article - trumpexcel.com/name-box-excel/
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzbin.info...
#Excel #ExcelTips #ExcelTutorial

[@trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

[@IvanCortinas_ES]

Excellent explanation as always, very detailed. Very good VBA trick. I didn't know about this functionality. Thank you very much, Sumit!

[@trumpexcel]

Thanks Iván 🙂 So many hifdden tricks in Excel. I learn something new every now and then. Another thing I learned but didn't cover in the video is that if you enter r in the name box and hit enter, It will select the entire row of the active cell. And if you enter c in the name box and hit enter, It will select the entire column of the active cell.

[@IvanCortinas_ES]

@@trumpexcel Supertricks! Thank you for this bonus!!

[@sujitsengupta8398]

As always - this also is an excellent and useful tip!

[@trumpexcel]

Thanks Sujit... Glad you found the video useful 🙂

[@sakisl7739]

I ' ve been wondering what is the use of it! Great!

[@chandramohan1418]

SOLVER feature. Detail explanation .thank yu

[@Satwant2463]

Wow so handy. Thank you.

[@joshuamanampiu6489]

Excellent

[@TVSCDN]

Thanks🎉🎉🎉❤❤❤😊

[@trumpexcel]

Glad you found the video useful 🙂

[@nadermounir8228]

This is a great video 📹 👍

[@balajimallela333]

Nice video bro

[@buddiephotographer]

Interesting

[@chandramohan1418]

Pl a video on Excel for Fianancial professionlas in real time practices.thank yu

[@abhishekpandey21790]

can we get formulas / equations also, this will help me copy sample calculations to new sheets quickly

[@arunkumarmadhavan9030]

Please help us with sharing Macro basic

[@HusseinKorish]

Perfect

[@trumpexcel]

Glad you found the video helpful 🙂

[@jamshaidkhan6661]

❤

[@abhishekpandey21790]

One query : suppose i identified few cells with the help of conditional formatting and got them highlighted. What shall I do to retain color after removing conditional formatting?

[@basilmoore47]

Is there a way to print instructions for "name" box in execl?

[@Saurabh-mv2sd]

Dear Sumit, Can you explain if there is any function in Ms Excel which can be used to prevent those wrong duplicate entries which are entered by pressing Control + D while pressing Control + C shortcut key. I have searched for this problem but couldn't find it's solution.

[@venumadhav2284]

What if the one tries to name a routine in VBA and a named range the same will excel throw any duplication prompt or should care be taken while naming VBA routines and named ranges

[@trumpexcel]

In that case, the named range takes precedence

[@abhishekpandey21790]

Hi, can we get filtered value in cell, like if a column has 10 values and we apply filter over it, now if in filter drop down i select one of the value, now this value shall get copied in one of the cell i want

[@trumpexcel]

I thing this can be done with VBA. Not sure if there is a non-VBA method to do this

[@abhishekpandey21790]

@@trumpexcel thanks for responding

[@abhishekpandey21790]

any technique to use name box to name table, not column/row alone ?

[@trumpexcel]

I don't think you can name a table with a Name Box. You can do that from the Table Design tab that appears in the ribbon when you select any cell in the Excel Table

[@abhishekpandey21790]

@@trumpexcel i checked it Today, we can name a table too . basically giving a name in name box to a table.

[@trumpexcel]

@@abhishekpandey21790 If you're talking about tabular data (and not the official Excel Table), then yes, you can. But if you have converted it to an Excel Table, then you can not change the name from Name Box.

[@abhishekpandey21790]

​@@trumpexcelyes only tabular data, agree that no editing possible. I was wondering if we can copy equations with formulas too that allows editing, that would just make work too faster

[@niravvaniya777]

Sir i have excel file with vba .. so vba tooks 30 min to run it for 1 data i have 2000 data so any cloud platform their provide run excel with vba .. any solution tnx

[@gauravkhiwasara]

Instead of VBA try power query for it will do the work in few minutes

[@niravvaniya777]

@@gauravkhiwasara power query not possible it's so complicated in vba also.

[@abhishekpandey21790]

You are my chatgpt

[@trumpexcel]

🙂

[@abaidurrehman1888]

formula is not working properly it shows only one value in that row