📊Excel Shortcut

Copy Formula from Cell Above

Detailed guide to use "Copy Formula from Cell Above" in Excel

Shortcut Keys

The highlighted keys show where to press. Press the required keys together.

Windows

Ctrl
'

Windows shortcut: Ctrl+'

Mac

Ctrl
'

Mac shortcut: Ctrl+'

In Action

This shows a representative pseudo-Excel example of what happens after the shortcut runs. The actual Excel UI may differ slightly.

Auto-playing example
Active: D2Selection: D2Sheet: Sheet1Step 1/3

You can scroll the sheet horizontally

↶↷BIUGeneral
Name Box
D2
Formula Bar
fx=B2-C2
◢
A
B
C
D
1
Month
Sales
Cost
Margin
2
Jan
2000
1400
600
3
Feb
1850
1300
4
Mar
2100
1500
600
Sheet1
Ready100%

Basic Info

Category
Editing
Difficulty
★★★(Avancé)

How to Use

  1. 1Select the target cell/range if needed
  2. 2Press the highlighted keys shown above together
  3. 3Copy Formula from Cell Above is executed

Practice

Practice this shortcut and build reliable muscle memory.

Start Shortcut PracticeSee Practice ModesCommencer les fonctions

Usage Tip

Copy the formula from the cell directly above into the active cell.

Related Shortcuts

Insert/Edit Comment

Same category
Shift + F2

Insert Hyperlink

Same category
Ctrl + K

Toggle Formula View

Same category
Ctrl + `

Toggle Reference Type

Same category
F4

Copy Value from Cell Above

Same category
Ctrl + Shift + 2

Apply Date Format

Same category
Ctrl + Shift + 3

Apply Currency Format

Same category
Ctrl + Shift + 4

Apply Percentage Format

Same category
Ctrl + Shift + 5

More In This Category

Clear Cell Contents

Delete

Redo

Ctrl + Y

Underline

Ctrl + U
View Full Shortcut List

FAQ

What is the shortcut for Copy Formula from Cell Above?

Windows: Ctrl+'. Mac: Ctrl+'.

How do I use Copy Formula from Cell Above?

Use it after selecting the target cell or range to speed up edits and fixes.

What shortcuts should I practice after Copy Formula from Cell Above?

Practice copy, line break in cell, and reference toggle next and you can move through common Excel work much faster.

Where can I practice Copy Formula from Cell Above?

Use the page button to start a focused drill right away. If you switch to full practice, you can review copy, line break in cell, and reference toggle in the same flow.

What is the action preview for Copy Formula from Cell Above?

A visual pseudo-Excel simulation showing the before and after state when you run the shortcut.

← Back to ListExcelGym Home