Look Who it Was Random video

Excel - Add Frequently Used Commands to QAT in Excel - Episode 930

471 views · Published 16 January 2009 · 3:28 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Add Frequently Used Commands to QAT in Excel.

Welcome back to the MrExcel netcast! I'm Bill Jelen and since the beginning of the year, I've made a resolution to use Excel 2007 and read up on all the latest features. However, it hasn't always been my go-to choice. In this week's podcast, we've been discussing Jim's question on how to consolidate data from different worksheets. As I reflected on what was driving me crazy about the new Excel, I realized that one of the biggest frustrations for me was sorting data.

In previous versions of Excel, we had a convenient AtoZ button for sorting data, but in Excel 2007, it's a two-click process. You either have to open the SORT & FILTER menu and choose SMALLEST TO LARGEST, or click on DATA and then AtoZ. Wouldn't it be easier if we had one-click access to this feature? That's where the Quick Access Toolbar comes in.

By default, the Quick Access Toolbar is located above the ribbon with only three icons. However, I prefer to have it below the ribbon for easier access and more space for icons. You can right-click on the toolbar and select "Show Below the Ribbon" to make this change. Now, whenever you come across a command that you wish was easily accessible, simply right-click on it and select "Add to Quick Access Toolbar." This way, you'll have all your frequently used commands in one convenient location.

In this week's podcast, we've discussed four different ways to solve Jim's problem of consolidating data from different worksheets. If you have a different method that you'd like to share, please feel free to drop me a note at [email protected]. I'd love to hear from you and feature your method in a future podcast. Thanks for tuning in and we'll see you next time for another netcast from MrExcel. Don't forget to subscribe to our channel for more Excel tips and tricks!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


It is frustrating that commands in Excel 2007 are spread out amongst 7 different ribbon tabs. Episode 930 will show you how to add your favorite commands to the QAT - Quick Access Toolbar so that you can have one-click access to these commands.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Table of Contents:
(00:00) Introduction to the MrExcel netcast
(00:15) Bill's resolution to use Excel 2007
(00:25) Discussion of Jim's question about consolidating data
(00:35) Frustration with sorting data in Excel 2007
(01:05) Using the quick access toolbar to access frequently used commands
(02:00) Adding sorting commands to the quick access toolbar
(02:50) Recap of solutions for Jim's problem
(03:05) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Adding commands to the quick access toolbar
AtoZ and ZtoA sorting in Excel 2007
Consolidating data in Excel 2007
Contacting MrExcel for additional help or methods
Excel 2007 tips
Minimizing the ribbon in Excel 2007
Quick access toolbar in Excel 2007
Solving data on different worksheets in Excel 2007
Sorting data by order in Excel 2007
Sorting data in Excel 2007
Transition from Excel 2003 to Excel 2007
Using the quick access toolbar in Excel 2007


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152092/

More from this channel