The Quick Access Toolbar is a useful tool, located at the upper-left corner of the Excel worksheet. It’s packed with all the commonly used commands and functions.
The Fill Color tool is easily found in the Home tab. But sometimes the Fill Color icon is not easily visible at the Home tab due to the customization of the Ribbon or any other reason. In that case, you can the Fill Color icon to the Quick Acces Toolbar for a better experience.
In this article, you will learn 2 ways to add the Fill Color icon to the Quick Access Toolbar in Excel from the Ribbon and by customizing the Quick Access Toolbar.
Look at the below image before and after adding the Fill Color icon in the Quick Access Toolbar.
Here are 2 ways to add the Fill Color icon to the Quick Access Toolbar:
1. Using the Context Menu of Excel Ribbon
You can directly add the Fill Color icon to the Quick Access Toolbar by using the context menu of the Fill Color command in the Ribbon. This is the easiest and most convenient method when the Fill Color command is easily visible in the Ribbon.
To add the Fill Color icon to the Quick Access Toolbar using the ribbon in Excel:
- Right-click on the Fill Color icon of the Font group.
- Choose Add to Quick Access Toolbar of the context menu.
You can see the Fill Color icon has been added to the Quick Access Toolbar.
2. Customizing the Quick Access Toolbar
You can customize the Quick Access Toolbar in Excel to include the Fill Color icon through the Excel Options window. If the Fill Color icon is not easily visible in the Ribbon, this method allows you to access it conveniently from the Quick Access Toolbar.
To add the Fill Color icon to the Quick Access Toolbar by customizing it in Excel:
- Click on the Customize Quick Access Toolbar drop-down > More Commands. Or, right-click on any of the commands of the Quick Access Toolbar > Customize Quick Access Toolbar. This will take you to the Customize Quick Access Toolbar section of the Excel Options window.
- In the Excel Options window:
- Choose the Fill Color option from the box under the “Choose commands from” section.
- After that click on “Add >>”.
- The Fill Color command is added to the box right next to the “Add >>” button. Finally, press OK.
The Fill Color icon has been successfully added to the Quick Access toolbar.
Note: If your Quick Access Toolbar is not enabled, then go to File tab > Options > Quick Access Toolbar to access the “Customize the Quick Access Toolbar” section.
Read More: How to Add a Macro to Your Quick Access Toolbar in Excel
Conclusion
In this article, we’ve explored two easy ways to add the Fill Color icon to the Quick Access Toolbar in Excel. Adding this icon proves helpful when you’re in a tab other than Home and need to use Fill Color quickly. It’s also useful if you can’t find this tool in its default place after customization. If you have any further questions about this article, feel free to write them in the comment box.
Frequently Asked Questions
Can I relocate the Fill Color icon on the Quick Access Toolbar?
Yes, you can customize the position of the Fill Color icon on the Quick Access Toolbar. Follow the steps for that:
- Go to the File tab > Options.
- In the Excel Options dialog box, click on the Quick Access Toolbar.
- Select the Fill Color command from the box under the Customize the Quick Access Toolbar.
- Click on the Move Up or Move Down buttons on the right side to change the order of icons.
How to share my customized Quick Access Toolbar settings with others?
You can share your customized Quick Access Toolbar settings from the Excel Options window. Follow the steps below for details:
- Go to the File tab > Options.
- In the Excel Options dialog box, click on the Quick Access Toolbar.
- After that, access the Import/Export drop-down of the Customizations section.
- Select Export all customizations and save the Exported Office UI file in the File Explorer.
- Finally, share this file with others to access your customized Quick Access Toolbar settings.
What is the keyboard shortcut for the Fill Color command in Excel?
The keyboard shortcut for the Fill Color command in Excel is Alt + H + H.
<< Go Back to Customize Quick Access Toolbar | Quick Access Toolbar in Excel | Excel Parts | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!