No video :(

Did You Know this Excel Quick Access Toolbar Hack? 🔥

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

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

50% 1

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

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

7 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

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

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

@bjbrooks 5 месяцев назад

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

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

Thanks Brian.. Glad you found the video useful 🙂

@fernandesotiso8071 5 месяцев назад

You are a solution to this generation...Thanks

@ldsheffield 5 месяцев назад

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!!!!

@SaeedDakeen 5 месяцев назад

Awesome one. Cheers mate

@akhiljain1429 5 месяцев назад

Very useful. Thanks.

@mekini4851 5 месяцев назад

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

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

Thank you 👍🏼

@user-iu8sn6mw1z 5 месяцев назад

Love this! Thank you!

@WekomVideos 5 месяцев назад

This is genius, thank you sir!

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

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

@mustavogaia2655 5 месяцев назад

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

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

@user-gr5wh8lf6r 5 месяцев назад

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

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

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 🙂

@frenan82 5 месяцев назад

Loooove that. Thanks !

@jitamdhuvad6342 4 месяца назад

thanks buddy. As always amazing content.

@KashifKhan-it6rb 5 месяцев назад

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

Thank you so much for the kind words Kashif!!

@user-qe1zs1gz3j 5 месяцев назад

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

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

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

@lazyreviewssupport9811 5 месяцев назад

Thumbs 👍 added 😅

@IvanCortinas_ES 5 месяцев назад

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

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

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.

@tfjohnson55 5 месяцев назад

Oh MY !

@GP-rx7xd 5 месяцев назад

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

@SarangManzoor 5 месяцев назад

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.

@nazarkamal8831 5 месяцев назад

👍👍👍👍👍

@RichardJones73 5 месяцев назад

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

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

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

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!