Filling colors in cells in Excel could be quite useful.
It allows you to identify and highlight data, flag errors, or just make your data more visually appealing.
In this tutorial, I will give you the keyboard shortcut to fill color cells in Excel
Shortcut to Fill Color in Excel
Below is the keyboard shortcut to Fill Color in Excel:
ALT + H + H
The above keyboard shortcut would open the Fill Color menu from where you can choose any of the colors that you want to fill in the selected cells.
Unfortunately, there is no keyboard shortcut that will allow you to quickly fill a specific color in the selected cell.
Once you have opened the fill color menu, you will have to use the arrow keys to navigate to the color that you want to fill and then use it
How to Use the Keyboard Shortcut to Fill Color in Excel
Below are the steps to use the above keyboard shortcut:
- Select the cell or range of cells in which you want to fill the color (you can even choose a non-contiguous range of cells)
- Use the above keyboard shortcut (Alt + H + H) to open the Fill Color menu. You need to press these keys one after the other
- Use the arrow keys to navigate within the Fill Color menu, and once you have selected the color that you want to use, hit the Enter key. Once the Fill Color menu is open, you can also use your mouse to select the color that you want to fill
Also read: How To Replace Blank Cells With 0 In Excel
Important Things to Know About Fill Color in Excel:
- If you want to remove the color from some of the cells, first select the cells, open the Fill Color menu, and then click on ‘No Fill’
- If you want more color options (apart from the one that are already shown in the Fill Color menu, click on the ‘More Colors’ option)
- The color options that you see in the Fill Color menu are dependent on the based on the current theme that is applied in Excel. If you change the theme, these colors would accordingly change
- You can also fill colors in a cell by using the Cell Styles option (it’s in the Home tab in the Cells group). When you click on the Cell Styles option, it shows you some of the pre-made cell formats that you can use (which also include different fill colors that you can use)
- When you fill a color in a cell, it would not change based on the value of the cell. In case you want to change the color of the cell based on its value, you should use Conditional Formatting instead
Alternate Ways to Fill Color in Excel:
Since the keyboard shortcut to fill color in excel is not straightforward (as the best it does is open the fill color menu and you have to choose the color manually), you can also use the alternative way by using the ribbon and manually selecting the color.
Below are the steps to open the Fill menu and fill the color in the cells in Excel:
- Select the cells in which you want to fill the color
- Click the Home tab
- In the Font group, click on the Fill Color menu icon
- Choose the color from the options
Some Other Useful Fill Color Shortcuts
Here are some other ‘Fill Color’ related keyboard shortcuts that you will find useful.
To remove the color which is already applied on a cell or range of cells:
ALT + H + H + N
To get more colors option (in case you want more colors than the ones shown in the Fill Color menu)
ALT + H + H + M
Other Excel shortcuts you may also like:
- Excel Keyboard Shortcuts
- Edit Cell in Excel
- Merge or Unmerge Cells in Excel
- Copy and Paste in Excel (Shortcut)
- Apply Border to Cells in Excel (Shortcut)
- Format Cells Options in Excel (Shortcut)
- Format Painter in Excel
- Fill Right in Excel (Shortcut)
Other Excel Tutorials You May Also Like:
- How to Change Font Color Based on Cell Value in Excel?
- How to Remove Conditional Formatting in Excel? (5 Easy Ways)
- How to Paste without Formatting in Excel (Shortcuts)
- How to Strikethrough in Excel (Shortcuts)
- Control E in Excel – What Does it Do?
- How to Filter by Color in Excel?
- How to Remove Strikethrough in Excel?