From the course: 20 Nano Tips for Maximizing Excel with Mike Tholfsen

Unlock this course with a free trial

Join today to access over 25,200 courses taught by industry experts.

Excel Quick Access Toolbar

Excel Quick Access Toolbar

From the course: 20 Nano Tips for Maximizing Excel with Mike Tholfsen

Start my 1-month free trial Buy for my team

Excel Quick Access Toolbar

“

- [Instructor] How to add your favorite Excel buttons to the quick access toolbar. So I can go to any button and right click, like this. I'm going to drop down, sort and filter, right click, add to quick access toolbar. And it adds a little button here. Let's add a few more. Pivot tables, conditional formatting, insert a row, delete a row. And everybody's favorite, sum. Now I've got my little buttons here. So for example, I can select a bunch of sales here and click Filter, and I get a filter. If I want to make a pivot table, I just click there, insert a row, or delete a row. And if I want to auto sum something, check it out.

Contents