Old Alt + Menu Keyboard Shortcuts. To use a custom color, click More Colors, and then in the Colors dialog box select the color you want. As we can see above, this works like in-cell editing . To use this, just click on the Fill Color icon in the QAT and itll show you the palette of colors that you can choose from. After pressing Ctrl + C, select the target cell or range and use the Alt, H, V, R Paste Format keyboard shortcut. dropdown.parentNode.submit(); Hello! PC Shorcut: Ctrl + C Mac Shorcut: + C Remember This Shortcut: C for C opy Cut This Excel Shortcut cuts the current selection. Ctrl+End. Macros & Excel VBA -Select the cell or range of cells you want to format. There is a direct shortcut for No Fill Alt+H+H+N. This will open the menu so you can view the color palette, but you have to take additional steps to select and apply the color. Excel displays the Replace Format dialog box. The result of the worksheet will look like this. Go to the, Now, exit the Microsoft Visual Basic for Applications window and go to the. Now you can use the below keyboard shortcuts to fill color in selected cells in Excel. Choose Background from the Page Setup group. Tanjim Reza Tanim. Use Tab Color from the Home Tab. Because a sheet background is not printed, it cannot be used as a watermark. dropdown.onchange = onCatChange; 4. d. In the Press new keyboard shortcut, assign the shortcut key (we used control + Shift+ Z) e. After assigning, click on OK. First, select the entire sheet or a range of cells where you want to apply the background color formatting, and then go to the "Home" tab. The F4 key can be a one-step solution to applying font and fill colors. Thank you very much for the knowledge shared, You are a hero because you save my time (F4). /* ]]> */, How to Change Background Color in Excel (6 Easy Methods), 6 Simple Methods to Change Background Color in Excel, 1. None of the workaround methods really accomplish this, so I created an Excel add-in that will allow you to customize your own shortcuts. Now, whenever you click on a cell between the declared range, the cell background will turn into light green color.