Did You Know this Excel Quick Access Toolbar Hack? 🔥

Excel Quick Access Toolbar (QAT) allows us to add commonly used features to it so that we can quickly access them.
In this video, I will show you a simple shortcut trick that will allow you to access these features with an easy shortcut.
00:23 Intro
00:00 Adding Functionalities to the Quick Access Toolbar
01:03 Shortcut to access options in the Quick Access Toolbar
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ 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

[@masumraja3827]

Sumit Sir....your videos are always helpful. I have a request,please make detailed videos on Sumproduct function,please a playlist for it possible. -Thanks Masum

[@fernandesotiso8071]

You are a solution to this generation...Thanks

[@ldsheffield]

This was very helpful and insightful, love learning new things!! I too love keyboard shortcuts!! Thank you Sumit for taking the time to share your knowledge with us by making this videos! Thank you for all you do, you are appreciated!!!!

[@bjbrooks]

Very nice. I've been using Excel for 30+ years, and learned something! Good pace of video too. Thank you! 🙂

[@trumpexcel]

Thanks Brian.. Glad you found the video useful 🙂

[@akhiljain1429]

Very useful. Thanks.

[@mekini4851]

Thank you for sharing these excellent tricks which help me in my daily work. Much appreciate your efforts and guidance! 👍🏼👍🏼

[@SaeedDakeen]

Awesome one. Cheers mate

[@Satwant2463]

Thank you 👍🏼

[@user-gr5wh8lf6r]

Very nice. I've been learned something very interesting! Good pace of video too. Thank you! 🙂

[@trumpexcel]

Thanks... Glad you found the video helpful. People always tell me I speak fast and I have been working on it, so the feedback on pace is good to hear 🙂

[@WekomVideos]

This is genius, thank you sir!

[@trumpexcel]

Thanks for commenting... Glad you found the video useful 🙂

[@mustavogaia2655]

This hack is very good - I've been using it a lot for macros. One can also put a button connected to a macro and the ""Alt+number" trick works fine.

[@trumpexcel]

Yeah, you can also put macro icons and run a macro with the shortcut. I use this all the time

[@user-iu8sn6mw1z]

Love this! Thank you!

[@frenan82]

Loooove that. Thanks !

[@lazyreviewssupport9811]

Thumbs 👍 added 😅

[@tfjohnson55]

Oh MY !

[@jitamdhuvad6342]

thanks buddy. As always amazing content.

[@user-qe1zs1gz3j]

I so appreciate your videos! Thank you for taking the time. :)

[@trumpexcel]

Thanks Rebecca... Glad to know you're finding value in the videos 🙂

[@KashifKhan-it6rb]

The kind of knowledge you have Sumit is Amazing. I always wait for your Magic. This one is one of the best HACKS. Appreciate you efforts... Keep Shining!!!!!

[@trumpexcel]

Thank you so much for the kind words Kashif!!

[@IvanCortinas_ES]

Excellent trick. It saves a lot of time. Thank you very much for sharing, Sumit.

[@trumpexcel]

Thanks for commenting Iván... While I've known this for many years I recently started using it and I find it to be a good time saver.

[@GP-rx7xd]

Good morning. Could you please add a video to show how to disable the keyboard in excel. I wouldn't like to disable the inputs but only inputs via the keyboard. Thanks

[@nazarkamal8831]

👍👍👍👍👍

[@SarangManzoor]

Dear Sumit Bansal Sir, is there a way in the pivot table to use two filters on filters section (I am Talking about Pivot table field list) having one field. For example: i want to keep the daily target of a salespersons by selecting day 1, and then calculating their total sales by using another filter having identical filter from the filter section to include day 1 to day 5 total to get the total sales from the same filter available twice (if possible). Because target is same for all days for a sales person. so if i want to see two days performance combined performance, it also sums up both days target and provide wrong results.

[@RichardJones73]

The one I struggle with is getting quick access to center across selection. How do I do that?

[@trumpexcel]

While I couldnt find the option to add Center Across Selection to the Quick Access Toolbar, a workaround would be to have a macro that does that and then add the macro in the QAT. Here is the code that would do this: Sub CenterAcrossSelection() Selection.HorizontalAlignment = xlCenterAcrossSelection End Sub You can save this code in your Personal Macro Workbook, and then it would work on every workbook on your system

[@tfjohnson55]

I have used a Center-Across similar to Sumit's for years and is just about the #1 button in my QAT. I hate merged cells so I thank the Excel Higher Powers for Center-Across!