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
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.
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.
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 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.
@@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
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?
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
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
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
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
As always - this also is an excellent and useful tip!
Thanks Sujit... Glad you found the video useful 🙂
I ' ve been wondering what is the use of it! Great!
can we get formulas / equations also, this will help me copy sample calculations to new sheets quickly
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.
Is there a way to print instructions for "name" box in execl?
❤
Excellent explanation as always, very detailed. Very good VBA trick. I didn't know about this functionality. Thank you very much, Sumit!
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.
@@trumpexcel Supertricks! Thank you for this bonus!!
any technique to use name box to name table, not column/row alone ?
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
@@trumpexcel i checked it Today, we can name a table too . basically giving a name in name box to a table.
@@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.
@@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
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?
formula is not working properly it shows only one value in that row
Please help us with sharing Macro basic
Thanks🎉🎉🎉❤❤❤😊
Glad you found the video useful 🙂
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
In that case, the named range takes precedence
Interesting
SOLVER feature. Detail explanation .thank yu
Pl a video on Excel for Fianancial professionlas in real time practices.thank yu
You are my chatgpt
🙂
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
I thing this can be done with VBA. Not sure if there is a non-VBA method to do this
@@trumpexcel thanks for responding
Wow so handy. Thank you.
This is a great video 📹 👍
Nice video bro
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
Instead of VBA try power query for it will do the work in few minutes
@@gauravkhiwasara power query not possible it's so complicated in vba also.
Excellent
Perfect
Glad you found the video helpful 🙂