Function Problems

Excel F4 Does Not Repeat Font Color Formatting

Olivia MillerOlivia Miller Nov 13, 2026 869 views

Question details

The user wants to repeat a recent font color change in Excel using F4.

Why Excel F4 Does Not Repeat Font Color Formatting
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.
Before you start

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.

Solution 1Recommended

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.

1
Change the font color

Select a cell, then use Home > Font Color to apply the desired color.

2
Select the next cell

Click the cell you want to format without entering cell edit mode.

3
Check Repeat

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.

Check whether Excel can repeat the font color change
F4 does not repeat every action: F4 working for row insertion confirms that the key can trigger Repeat, but it does not guarantee that every formatting action can be repeated.
Free Microsoft Office alternative

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.

Apply font colors and copy cell formatting in WPS SpreadsheetsCompatible with Microsoft Excel formats including XLSX and XLSFamiliar ribbon-style interface makes switching easierFree and lightweight for everyday spreadsheet work
microsoft office alternative - wps office

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.