Need to learn how to add the Fill Color icon to the quick access toolbar in Excel? Often, we use the Fill Color icon to change the background color of the cell. We also use it to highlight cells. If you are looking for such unique kinds of tricks, you’ve come to the right place. Here, we will take you through 5 easy and convenient methods for adding the Fill Color icon to the Quick Access Toolbar (QAT) in Excel with appropriate illustrations.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice yourself.
5 Methods to Add the Fill Color Icon to the Quick Access Toolbar in Excel
While working in Excel, we have to use the Fill Color tool every now and then. Sometimes, it becomes bothersome to find it from the Home tab ribbon. So, it would be very convenient to get the icon on the quick access toolbar.
Here, we have a Region-wise Sales Report of a certain company.
In the picture above, we can clearly see that the Fill Color tool is available on the Home tab ribbon. But, it’s not on the quick access toolbar. The quick access toolbar contains just the Save icon. Now, we’ll add this Fill Color icon to the quick access toolbar too. So, without further delay, let’s jump into the procedures below.
Here, we have used Microsoft Excel 365 version, you may use any other version according to your convenience.
1. Using Fill Color Icon to Add It on Quick Access Toolbar in Excel
In our first method, we’ll use the Fill Color icon on the ribbon to add it to the quick access toolbar in Excel. Let’s follow along.
📌 Steps
- First of all, open the worksheet.
- Secondly, go to the Home tab.
- Thirdly, right-click on the Fill Color icon.
- Then, select the Add to Quick Access Toolbar option.
- Instantly, the Fill Color icon will be available on the quick access toolbar just as in the image below.
- At this moment, we’ll use this icon on the quick access toolbar to test its functionality.
- For that, select cells B4 and F4.
- Then, click on the arrow beside the Fill Color icon on the quick access toolbar.
- After that, choose a suitable color. In this case, we chose Gold, Accent 4, and Lighter 80%.
- Simply, we can change the background color in this way.
2. Utilizing Any Command on Quick Access Toolbar in Excel
Looking for more ways to add the Fill Color icon to the quick access toolbar? Then, you’ve come to the right place. Follow these simple steps below.
📌 Steps
- In this worksheet, we can see the Save and Undo icon on the quick access toolbar.
- First, right-click on the Save icon on the quick access toolbar.
- Then, select the Customize Quick Access Toolbar option.
- Suddenly, the Excel Options window appears.
- Afterward, select Fill Color from the Choose commands from section.
- Then, click on the Add button.
- Eventually, the Fill Color tool will appear in the right box as shown in the image below.
- Finally, tap on the OK button.
- Subsequently, the Fill Color icon appears on the quick access toolbar.
Read More: How to Show Quick Access Toolbar in Excel (5 Easy Ways)
3. Taking Advantage of Down-Head Arrow Icon on Quick Access Toolbar
You might be wondering, is there another way to add this icon to the quick access toolbar? Then you’re lucky. Just follow along.
📌 Steps
- Firstly, click on the down-head arrow at the most right of the quick access toolbar.
- Following this, click on the More Commands from the list.
- Again, it opens the Excel Options window like before.
- Later, select Fill Color from the Choose commands from section.
- Additionally, click on the Add button.
- Eventually, the Fill Color tool will appear in the right box as shown in the image below.
- Finally, tap on the OK button.
- Finally, the Fill Color icon appears on the quick access toolbar.
4. Making Use of File Tab
For those of you who want to explore more techniques, there is another possible way. Let’s explore the method step by step.
📌 Steps
- Initially, go to the File tab.
- Then, select Options from the menu.
- Instantly, it will open up the Excel Options window.
- Afterward, move to the Quick Access Toolbar tab.
- Moreover, select Fill Color from the Choose commands from section.
- Then, click on the Add button.
- Eventually, the Fill Color tool will appear in the right box as shown in the image below.
- Lastly, tap on the OK button.
- Thus, we can see the Fill Color icon appearing on the quick access toolbar.
5. Applying VBA Code
As with Excel, there are multiple ways of doing the same work. In fact, you can replace the prior methods with the help of VBA. So, allow me to demonstrate the process step-by-step.
📌 Steps
- At the very beginning, proceed to the Developer tab.
- After that, select Visual Basic from the Code ribbon group.
Note: Also, you can do the same work by pressing the ALT + F11 key.
- Immediately, it will open the Microsoft Visual Basic for Applications window.
- Later, go to the Insert tab.
- Additionally, select Module from the options.
- Instantly, it will open up the code module window.
- Now, write down the following code in the code module.
Sub Fill_Color()
Selection.Interior.Color = vbYellow
End Sub
- At this moment, right-click on the Fill Color icon on the quick access toolbar.
- Then, select Customize Quick Access Toolbar from the options.
- As usual, the Excel Options window appears like in Method 2.
- At first, choose Macros from the Choose commands from the drop-down list.
- Simply, select our newly created macro Fill_Color from the list.
- Then, click on the Add button.
- Lastly, hit the OK button.
- Correspondingly, the Fill_Color icon appears on the quick access toolbar.
- To test its functionality, select cells B4 and F4.
- In time, click on the Fill_Color icon on the quick access toolbar.
- Simply, we can change the background color in this way.
Read More: How to Add a Macro to Your Quick Access Toolbar in Excel
How to Remove the Fill Color Icon from Quick Access Toolbar in Excel
Don’t you need the Fill Color icon on the quick access toolbar anymore? Do you want to make it vanish from the toolbar? Yes, obviously, you can do that also. Let’s see the process in detail.
📌 Steps
- Before going into the details, take a look at the image below.
- Obviously, you can see the Fill Color icon present on the quick access toolbar.
- At this point, right-click on this icon.
- Then, tap on the Remove from Quick Access Toolbar option.
- Surprisingly, you can see the Fill Color icon gets vanished from the quick access toolbar after our previous action.
Read More: How to Remove Quick Access Toolbar in Excel (3 Easy Ways)
Practice Section
For doing practice by yourself, we have provided a practice section like below in the last sheet Practice Section on the workbook. Please do it by yourself.
Conclusion
This article provides an easy and brief solution to add the Fill Color icon to the quick access toolbar in Excel. Don’t forget to download the Practice file. Thank you for reading this article, we hope this was helpful. Please let us know in the comment section if you have any queries or suggestions. Please visit our website, Exceldemy, to explore more.