No video :(

5 Clever Name Box Tricks in Excel 🤯

Подписаться 375 тыс.

Просмотров 12 тыс.

50% 1

☕ 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: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial

Опубликовано:

7 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 40

@trumpexcel 6 месяцев назад

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 6 месяцев назад

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

@trumpexcel 6 месяцев назад

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 6 месяцев назад

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

@sujitsengupta8398 6 месяцев назад

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

@trumpexcel 6 месяцев назад

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

@sakisl7739 6 месяцев назад

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

@chandramohan1418 6 месяцев назад

SOLVER feature. Detail explanation .thank yu

@Satwant2463 6 месяцев назад

Wow so handy. Thank you.

@joshuamanampiu6489 6 месяцев назад

Excellent

@abhishekpandey21790 3 месяца назад

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

@chandramohan1418 6 месяцев назад

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

@nadermounir8228 6 месяцев назад

This is a great video 📹 👍

@buddiephotographer 6 месяцев назад

Interesting

@TVSCDN 6 месяцев назад

Thanks🎉🎉🎉❤❤❤😊

@trumpexcel 6 месяцев назад

Glad you found the video useful 🙂

@HusseinKorish 6 месяцев назад

Perfect

@trumpexcel 6 месяцев назад

Glad you found the video helpful 🙂

@balajimallela333 6 месяцев назад

Nice video bro

@arunkumarmadhavan9030 6 месяцев назад

Please help us with sharing Macro basic

@abhishekpandey21790 3 месяца назад

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?

@Saurabh-mv2sd 6 месяцев назад

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.

@jamshaidkhan6661 6 месяцев назад

❤

@basilmoore47 6 месяцев назад

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

@venumadhav2284 6 месяцев назад

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 6 месяцев назад

In that case, the named range takes precedence

@abhishekpandey21790 3 месяца назад

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 3 месяца назад

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

@abhishekpandey21790 3 месяца назад

@@trumpexcel thanks for responding

@abhishekpandey21790 3 месяца назад

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

@trumpexcel 3 месяца назад

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 3 месяца назад

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

@trumpexcel 3 месяца назад

@@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 3 месяца назад

@@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 6 месяцев назад

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