Excel F4 Does Not Repeat Font Color Formatting
Question details
The user wants to repeat a recent font color change in Excel using F4.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- After changing a cell's font color, the user selects another cell and presses F4 to repeat the formatting.
- Observed behavior
- F4 repeats some actions, such as inserting rows, but does not repeat the recent font color change. Function keys are enabled, and the user reports that the behavior changed recently.
Select a cell outside edit mode and confirm that F4 can repeat another action, such as inserting a row. Make the font color change immediately before testing Repeat, since another action may become the most recent command.
Check whether Excel can repeat the font color change
Use the Repeat command to determine whether Excel supports repeating the most recent formatting action.
Excel cannot repeat every action. If the command displays Cannot Repeat after the font color change, Excel does not offer Repeat for that last action in the current context.
Select a cell, then use Home > Font Color to apply the desired color.
Click the cell you want to format without entering cell edit mode.
Check the Repeat command on the Quick Access Toolbar. If it is not visible, open the toolbar's customization menu and add Repeat. If it displays Cannot Repeat, the last action is not available for repetition.

Apply the font color without using F4
Use the Font Color button or Format Painter when Repeat is unavailable.
Repair Microsoft Office if other features also fail
Consider an Office repair when Excel has additional problems, not just an unsupported Repeat action.
Format spreadsheet cells with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and apply font colors or copy cell formatting as you continue working across Office formats.

Frequently Asked Questions
Why does F4 repeat row insertion but not a font color change?
Excel's Repeat command supports some actions but not others. If Repeat displays Cannot Repeat after the color change, that last action is not available for repetition in the current context.
Will Ctrl+Y repeat a font color change when F4 cannot?
Ctrl+Y can invoke Repeat, but it does not make an unsupported action repeatable. Check the Repeat command after applying the color to see whether it is available.
How can I apply the same font color to several cells?
Select the cells or range, then choose the color from Home > Font Color. You can also use Home > Format Painter to copy formatting from an existing cell.
Should I repair Office if F4 only fails for font formatting?
Not necessarily. First check whether Repeat displays Cannot Repeat for the action. Consider an Office repair if other Excel features are also malfunctioning.




