Excel Shortcut to Copy the Cell Above Into a Cell

In Excel for Microsoft 365 on Windows, select the cell below the one you want to copy, then press Ctrl+D to fill down from the cell above. On a Mac, use Command+D. If you select several rows, Excel fills each selected cell from the top cell in its column.

What Ctrl+D Does in Excel

Ctrl+D runs Excel’s Fill Down command. It copies the contents and formatting of the top cell in a selected range into the cells beneath it. With only one destination cell selected, Excel uses the cell immediately above as the source. This is why the shortcut works for a quick one-cell copy as well as for filling a longer range.

Fill Down is useful when a column needs repeated labels, values, or formulas. It is not limited to copying plain text. Depending on what is in the source cell, it can fill a constant value, a formula, or formatting. For example, selecting A2:A6 and pressing Ctrl+D uses A2 as the source and fills A3:A6. If you select B3 alone, Excel uses B2.

The command does not create a sequence. If A2 contains the number 5, filling down copies 5 into the selected cells; it does not produce 6, 7, and 8. To create a sequence, use Excel’s fill-series behavior or a formula instead. Ctrl+D repeats the source cell’s content rather than guessing what progression you intend.

How to Copy the Cell Above Step by Step

Click the cell that should receive the copied content. It must have a cell above it to use as the source.
Press Ctrl+D on Windows. Excel fills the selected cell from the one directly above.
To fill several rows, select the source cell and the destination cells together, then press Ctrl+D. The top row supplies the content for the rows below.

For example, to copy A2 through A10, select A2:A10 and press Ctrl+D. The selection must include A2; if you select only A3:A10, Excel treats A3 as the top cell of that selection and fills downward from it. This is a frequent source of confusion: the command fills from the top of the selected range, not necessarily from a cell outside the range.

You can also choose Home > Fill > Down on the ribbon. This performs the same operation and is useful if a laptop keyboard, remote desktop, or browser intercepts the shortcut. A ribbon command is also a handy way to confirm which operation Ctrl+D is meant to perform.

Examples With Values and Formulas

For a plain value, suppose A2 contains the text “Pending” and A3 is selected. Ctrl+D puts “Pending” in A3. If you select A2:A5 first, then press Ctrl+D, each cell from A3 through A5 receives the same text. This is appropriate for a repeated category or status, but not for a list that should vary from row to row.

With quantities in B2:B4 and unit prices in C2:C4, assume B2 is 3 and C2 is 12. Put this formula in D2:

=B2*C2

Select D2:D4 and press Ctrl+D. Excel copies the formula down and adjusts its relative references. If B3 is 4 and C3 is 12, D3 becomes 48; if B4 is 2 and C4 is 12, D4 becomes 24. The arithmetic is quantity multiplied by unit price: 4 × 12 = 48 and 2 × 12 = 24.

References that are locked with dollar signs behave differently. For example, a formula that refers to a fixed tax-rate cell using an absolute reference keeps pointing to that same cell when filled down, while ordinary relative references move with the row. Ctrl+D does not rewrite formulas to fit your intention; it applies Excel’s usual relative, absolute, or mixed-reference rules. Check the first filled result before relying on a large copied range.

Fill Down also copies the source cell’s formatting. If the top cell has a number format, font, fill color, or borders, those may be applied to the cells below along with the contents. If you need the formula or value but want to preserve destination formatting, use a paste option such as Formulas after copying, or choose the appropriate paste-special workflow rather than assuming Ctrl+D will retain the existing styles.

Ctrl+D Compared With Other Copy Shortcuts

Ctrl+D is the direct choice when the source is above the destination. It is different from the normal copy-and-paste sequence, Ctrl+C followed by Ctrl+V, which can copy a selected cell to a different location. Fill Down is especially convenient for a vertical range because it can fill many rows in one command and automatically adjust formulas as needed.

Two nearby shortcuts have narrower purposes:

Ctrl+D: fills selected cells downward from the top cell of the selection.
Ctrl+apostrophe: copies the formula from the cell above into the active cell. It is useful when you want the formula, rather than all the source cell’s contents and formatting.
Ctrl+Shift+double-quote: copies the value from the cell above into the active cell, rather than copying its formula as a formula.

These alternatives can be helpful when you want to control what is copied, but they are not interchangeable with Ctrl+D. If the source contains a formula and you want the result as a fixed value, copying the displayed value may be more appropriate. If you want the formula to recalculate for each row, fill the formula down and confirm that its references adjust correctly.

Choosing the Right Selection

Before pressing Ctrl+D, check which cell is at the top of the selection. Excel uses that row as the source, and for a multi-column selection it uses each column’s own top cell. For instance, if you select A2:C5, the contents of A2 fill down column A, B2 fills down column B, and C2 fills down column C. It does not copy A2 across the entire selection.

Use a selection that matches the job:

For one destination, select only that destination cell.
For several destinations in one column, select the source cell plus all destination cells below it.
For a rectangular block, include the source row and the intended rows beneath it; each column will fill from its own top cell.
If you do not want to replace the source cell, include it in the selection anyway, then remember that the source row remains the source while the lower cells are filled.

One practical safeguard is to glance at the Name Box or highlighted range before using the shortcut. If the wrong column or extra rows are selected, Ctrl+D can overwrite more cells than intended. Undo with Ctrl+Z immediately if the fill was accidental and no later action needs preserving.

Common Problems and How to Fix Them

The wrong content fills down: The top cell of the selected range is probably not the source you meant to use. Select the intended source and destinations together, or select just the destination cell if the source is directly above it.

A formula gives unexpected results: Relative references normally shift as a formula moves down. Inspect the formula in the first filled row and compare it with the original. If a reference should stay fixed, make it absolute with dollar signs before filling, or edit the copied formulas afterward.

The cells show the same number repeatedly: This may be the expected result if you filled a constant, or it may mean a formula uses fixed references. Ctrl+D does not increment numbers automatically. To generate a series, use the fill handle or a sequence-generating method appropriate to your data.

Formatting changes unexpectedly: Fill Down copies formatting from the top cell too. If the destination cells need to keep their existing appearance, use a method that pastes formulas or values only instead of the full Fill Down operation.

The command does nothing or is unavailable: A worksheet may be protected, cells may be part of a merged layout, or the selected range may not be suitable for filling. Check whether editing is allowed and whether the source and destination cells form a normal contiguous range. Merged cells can restrict operations when the merged areas do not match; unmerge or adjust the selection only if doing so is appropriate for the sheet.

A blank source erases existing content below: Fill Down copies the source cell’s contents, including the absence of content. If the top cell is blank, the fill can clear selected cells below. Verify that the source is populated before filling a range that contains data you need to keep.

Using the Shortcut on Mac and Excel for the Web

In Excel for Microsoft 365 on Mac, the equivalent Fill Down shortcut is Command+D. Keyboard layouts and system-level shortcuts can affect what happens, so the ribbon command Home > Fill > Down is a reliable alternative when the keystroke is unavailable or behaves differently.

Excel for the web also provides Fill Down. The keyboard shortcut can depend on the browser and operating system, because browsers may reserve key combinations for their own commands. If Ctrl+D opens a browser feature rather than filling the cells, use the ribbon command instead. In any version, first confirm the selected range and the source row; the selection logic is the important part of the operation.

Frequently Asked Questions

What is the shortcut to copy the cell above in Excel?
On Windows, select the destination cell and press Ctrl+D. In Excel for Mac, use Command+D. This runs Fill Down and copies from the cell above when only the destination is selected.

How do I copy a cell above into multiple cells?
Select the source cell at the top and all the cells beneath it that should receive the copy, then press Ctrl+D on Windows or Command+D on Mac. Excel fills downward from the top row of the selected range.

Does Ctrl+D copy formulas or just values?
It fills down the source cell’s contents, so it copies a formula as a formula and adjusts relative references. If the source is a fixed value, it repeats that value. It also copies formatting, which may be important when the destination cells already have a style.

Does Ctrl+D make a number series?
No. It repeats or fills the top cell’s contents; it does not infer that 5 should become 6 and then 7. Use the fill handle or a suitable series method when you need a numbered sequence.

Can I copy only the formula from the cell above?
Yes. On Windows, Ctrl+apostrophe copies the formula from the cell above into the active cell. For a broader range or to copy contents and formatting together, Ctrl+D is the standard Fill Down shortcut.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.