From the course: Excel: Productivity Tips
Unlock the full course today
Join today to access over 24,500 courses taught by industry experts.
Customizing the Excel ribbon tools - Microsoft Excel Tutorial
From the course: Excel: Productivity Tips
Customizing the Excel ribbon tools
- [Instructor] All right, hey, everyone. For this Pro Tip, I want to talk about customizing the workbook ribbon with your own tabs. Now, what a lot of Excel users don't realize is that you have full control to customize and personalize exactly what your ribbon looks like. So Excel has tools that allow you to add, remove or rearrange tabs and tools in your workbook ribbon, including the Quick Access Toolbar. Now, those Quick Access tools, they live above the ribbon above your main tabs and by default, they include options like Save, Undo and Redo. So a couple ways to customize those Quick Access tools. You can head to your File, Options pane and click into the Quick Access Toolbar tab. That's going to show you the list of tools included in that toolbar. Again, Save, Undo, Redo by default, and you can simply search for popular commands or tools and drag them into that list to customize the toolbar. But an easier way to do…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
(Locked)
Customizing the Excel footer4m 3s
-
(Locked)
Navigating workbooks with CTRL shortcuts8m 1s
-
(Locked)
Accessing ribbon tools with Alt key tips6m 53s
-
Accessing the Go To Special options4m 36s
-
(Locked)
Removing blank rows3m 17s
-
(Locked)
Creating drop-down menus with Data Validation7m 11s
-
(Locked)
Filling patterns with AutoFill and Flash Fill8m 26s
-
(Locked)
Customizing the Excel ribbon tools6m 53s
-
(Locked)
Splitting text to columns7m 39s
-
(Locked)
Synchronous scrolling across multiple workbooks2m 58s
-
(Locked)
Extracting unique values from a list4m 6s
-
(Locked)
Using named range and table references8m 12s
-
Protecting cells and formulas8m 9s
-
(Locked)
-