How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

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.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

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.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

  • Instantly, the Fill Color icon will be available on the quick access toolbar just as in the image below.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

  • 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%.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

  • Simply, we can change the background color in this way.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel


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.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

  • First, right-click on the Save icon on the quick access toolbar.
  • Then, select the Customize Quick Access Toolbar option.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

  • 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.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

  • Subsequently, the Fill Color icon appears on the quick access toolbar.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel


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.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

  • 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.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

  • Finally, the Fill Color icon appears on the quick access toolbar.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel


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.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

  • Then, select Options from the menu.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

  • 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.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

  • Thus, we can see the Fill Color icon appearing on the quick access toolbar.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel


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.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

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.

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

  • 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

How to Add the Fill Color Icon to the Quick Access Toolbar in Excel

  • At this moment, right-click on the Fill Color icon on the quick access toolbar.
  • Then, select Customize Quick Access Toolbar from the options.

Applying VBA Code

  • 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.

Applying VBA Code

  • Correspondingly, the Fill_Color icon appears on the quick access toolbar.

Applying VBA Code

  • To test its functionality, select cells B4 and F4.
  • In time, click on the Fill_Color icon on the quick access toolbar.

Applying VBA Code

  • Simply, we can change the background color in this way.

Applying VBA Code


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.

Removing the Icon

  • At this point, right-click on this icon.
  • Then, tap on the Remove from Quick Access Toolbar option.

Removing the Icon

  • Surprisingly, you can see the Fill Color icon gets vanished from the quick access toolbar after our previous action.

Removing the Icon


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.

Practice Section


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.

Shahriar

Shahriar

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc in Engineering from the Bangladesh University of Engineering & Technology. I am a Naval Architecture and Marine Engineering graduate with a great interest in research and development. I love reading books & traveling. Always try to gather knowledge from various sources and implement them effectively in my work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo