1
Ctrl + 1Set up the formatting on the first cell
Apply bold, color, number format, or whatever you need — just once, done right.
F4RepeatFormat Copy
Apply Formatting to Multiple Cells Instantly Using F4 (Repeat)
If you're applying the same bold, fill color, or border to multiple cells, F4 is often faster than copy-paste formatting.
Shortcuts you will master in this article
F4 / Ctrl + 1 / Ctrl + B
Repeating the Same Formatting Manually Is a Time Sink
Header styling, emphasis cells, alert highlights — these often need to be applied to several scattered locations. Returning to the ribbon for each one breaks your rhythm.
F4 is simply 'do that again' — and the range of things it can repeat is broader than most people realize.
How to Use F4
Do the operation once correctly, then use F4 to repeat it everywhere else.
2
Arrow keys to navigateMove to the next cell that needs the same treatment
Works for scattered cells, distant headers, or anything non-contiguous.
3
F4Repeat the last action
Instantly reapplies the same formatting.
4
F4 repeatedlyWork through all target cells at a steady pace
This is especially effective when the same action needs to be applied many times in sequence.
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Where F4 Makes the Biggest Difference
Bolding or color-coding headers, subtotals, or flagged items across a spreadsheet.
F4 can also repeat non-formatting actions like row insertion — it's not limited to formatting.
Ask yourself 'can I repeat this?' after each action — it expands how often you reach for F4.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
F4 | Repeat Last Action |
Ctrl + 1 | Format Cells Dialog |
Ctrl + B | Bold |
Frequently Asked Questions
Q. Isn't F4 also used to toggle absolute references? How do I keep them separate?
A. Yes — in cell editing mode, F4 cycles through reference types. In normal mode, it repeats the last action. The mode determines the behavior.
Q. Can F4 repeat any action?
A. Not all — it depends on the operation. Start with formatting repetition where the effect is immediately visible.
Q. How is this different from Format Painter?
A. F4 reruns the last action as-is. It's especially useful for scattered cells where you want to apply the exact same operation without selecting a source cell first.
Q. How do I memorize Excel shortcuts faster?
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →