To copy the cell above in Excel, select the source cell and the cell or range beneath it, then press Ctrl+D on Windows. Excel fills the selection downward with the upper cell’s contents and formatting. You can also copy and paste, or use the Fill Down command. This guide covers the safest method for a single cell, copying into several rows, and what to check if the result is not what you expected.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows. The steps also apply to many recent desktop versions of Excel.
- The cell you want to copy and the destination cell or range below it. Check that you are comfortable replacing anything already in the destination cells.
- For the keyboard method, a keyboard with a Ctrl key. On a Mac, use the Control key for Fill Down; on Excel for the web, the ribbon command is a useful alternative if the browser intercepts a shortcut.
Step-by-Step
- Identify the source cell. Find the cell directly above the place where you want the copy to appear. For example, if the value is in B4 and you want it in B5, B4 is the source and B5 is the destination. Confirm that the source has the value, formula, or formatting you intend to repeat.
- Select the source and destination together. Click the source cell, then drag down to include the destination. For the B4-to-B5 example, select B4:B5. You can also click B4, hold Shift, and click B5. Include the source at the top of the selection; Ctrl+D uses that top cell to fill the rest of the selected range.
- Fill down with the keyboard. Press Ctrl+D. The contents and formatting from the top cell are copied into the selected cell or cells beneath it. If you selected B4:B5, B5 now matches B4. If the source contains a formula, Excel copies the formula and normally adjusts relative cell references for the new row.
- Use the ribbon if you prefer menus. Keep the source and destination range selected, then choose Home > Fill > Down. This performs the same Fill Down action as Ctrl+D. It is especially handy when you are using Excel for the web and a browser shortcut gets in the way.
- Copy and paste as an alternative. Click the source cell and press Ctrl+C. Click the destination cell and press Ctrl+V. For a range of destinations, select the destination range before pasting. A moving dashed border around the source indicates that it is copied; press Esc when you are finished to remove that border.
- Copy into several consecutive rows. To repeat B4 down through B10, select B4:B10 and press Ctrl+D, or choose Home > Fill > Down. B4 stays as the source and the cells below it receive its contents and formatting. Check the full selected range before filling, because existing entries in B5:B10 will be replaced.
- Check the result before moving on. Click a filled cell and look at the formula bar to verify its value or formula. Check the displayed formatting too, including number format, borders, and fill color. If the cell contains a formula, inspect its references: a relative reference may shift one row, while an absolute reference marked with dollar signs remains fixed.
Mac and web notes: In desktop Excel for Mac, use the same selection method and press Control+D for Fill Down; the Command key is not the equivalent for this shortcut. You can also use Home > Fill > Down. In Excel for the web, the ribbon command works when available. Keyboard shortcuts can vary with browser settings, so use the ribbon if Ctrl+D triggers a browser action instead of filling cells.
Common Mistakes
- Selecting only the destination cell. Fill Down is most reliable when the selected range includes the source at its top. If you select just the cell below and press Ctrl+D, Excel may not have the intended source in the selection. Select both the upper cell and the destination, then fill down.
- Including the wrong top cell. Excel copies from the top of the selected range, not necessarily from the cell you had in mind. If you select B3:B6 when you meant to copy B4, Excel uses B3. Check the highlighted range before pressing the shortcut.
- Fill Down replaces contents in the cells below the source. If there are notes, formulas, or values in the range, they can be lost. Use Undo immediately with Ctrl+Z if you fill the wrong range, or save a separate copy before making a large change.
- Expecting only the value to copy. Ctrl+D copies cell contents and formatting, not just the visible text. It can bring across number formats, borders, font styling, and fill color. If you want only the value, use copy and then select Home > Paste > Paste Values from the paste options, or use the Paste Special options available from the paste menu.
- Assuming a formula will stay identical. Relative references often change as a formula is filled down. For example, a reference to A4 in a formula may become a reference to A5 in the next row. That is expected behavior when the reference is relative. Review the formula before relying on the copied result.
- Filling through a filtered list without checking hidden rows. A selected range can include rows hidden by a filter. Filling an entire range may affect cells that are not currently visible. Check the selection and consider copying into visible cells individually or adjusting the filter and range before filling.
Tips
- Use the Name Box for long ranges. The Name Box sits to the left of the formula bar. Type a range such as B4:B500 and press Enter to select it, then press Ctrl+D. Make sure the first cell in the range is the intended source before filling.
- Copy a cell down a whole block in one action. If the first cell contains a label, formula, or format that should be repeated, include it at the top of your selected range. This avoids repeatedly copying and pasting one row at a time.
- Choose Paste Values when formulas are not wanted. Normal pasting copies formulas as formulas. If you need the displayed results only, copy the source, select the destination, and choose the Values option under Home > Paste. This keeps the result but does not carry over the formula.
- Use the fill handle for a visual alternative. Select the source cell and point to the small square at the lower-right corner of its outline. Drag the fill handle down over the destination cells. Review the result because Excel may extend a series or pattern in some situations rather than simply repeat what you expected; the Auto Fill Options button can offer alternatives.
- Remember that Fill Down is different from filling a series. Ctrl+D repeats the top cell through the selected range. If you want a sequence such as 1, 2, 3, use the fill handle or the Series options rather than expecting Ctrl+D to invent the next number.
- Undo promptly if the selection was wrong. Ctrl+Z reverses the most recent fill or paste in desktop Excel. Check the affected cells before saving or doing more work, since additional actions can make it harder to identify the change you want to undo.
Troubleshooting
- Ctrl+D does nothing. Confirm that you selected at least the source cell and one or more cells below it. Then try Home > Fill > Down. If you are in a cell-editing state, press Esc or Enter to leave edit mode, select the range again, and retry.
- The wrong value or formula appears. The top cell of the selected range may not have been the intended source. Press Ctrl+Z, select the correct source and cells beneath it, and fill again. Check the formula bar if the displayed value does not reveal which formula was copied.
- The destination formatting changed unexpectedly. Fill Down copies formatting as well as contents. Undo and use copy-and-paste options that keep only the values or formulas you need. In the Paste menu, choose the option appropriate to your goal rather than using a full paste.
- The formula result is different in each row. Excel may have adjusted relative references when it copied the formula. If a reference should remain fixed, edit the original formula to use an absolute reference with dollar signs, then fill down again. Verify the formula in a lower row before filling a large block.
- You cannot change the destination cells. The worksheet may be protected, or the cells may be part of a restricted range. Check Review > Protect Sheet and ask the workbook owner for permission if needed. If the cells are merged, unmerge them or select a compatible range; Fill Down may not work across mismatched merged cells.
- The shortcut opens a browser feature. This can happen in Excel for the web because browser shortcuts may take precedence. Use Home > Fill > Down instead, or try the desktop Excel app where Ctrl+D is the Fill Down shortcut.
Frequently Asked Questions
Can I copy the cell directly above into just one cell?
Yes. Select both the upper cell and the cell below it, then press Ctrl+D. For example, select C7:C8 to copy C7 into C8. Selecting both cells makes the source explicit.
Does Ctrl+D copy formulas as well as values?
Yes. Fill Down copies the source cell’s contents, including a formula, and its formatting. Relative formula references generally adjust for the destination row; absolute references stay fixed.
How do I copy only the value and not the formatting?
Copy the source with Ctrl+C, select the destination, and use the Values paste option under Home > Paste. This pastes the calculated or typed value without copying the source cell’s normal formatting.
Can I copy one upper cell into multiple rows at once?
Yes. Select a range starting with the source cell and ending at the last destination row, then press Ctrl+D or choose Home > Fill > Down. The source must be the top cell of that selection.
Will copying a formula change its cell references?
It can. Relative references shift according to the new row or column, while absolute references with dollar signs do not shift. Inspect a filled formula to make sure it points to the intended cells.
What is the shortcut on a Mac?
In desktop Excel for Mac, select the source and destination range and press Control+D. If the shortcut is unavailable on your keyboard or behaves differently, use Home > Fill > Down.
Related
- Close a New Window in Excel Without Closing the Workbook
- How to Close a Hidden Dialog Box in Excel on Windows
- How to Close Microsoft Excel Without Losing Work
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Change Table Color in Excel: Styles and Custom FormattingTo change a table’s color in Excel for Microsoft 365 on Windows, click a cell in the table,…
- Excel Keyboard Shortcut to Insert Today’s DateIn Excel for Microsoft 365 on Windows, press Ctrl+; (Control plus the semicolon key) to insert today’s date…
- Python pandas Excel Formatting: A Practical Guide to StylesTo format an Excel file created with pandas, write the data with DataFrame.to_excel(), then apply styles with pandas…
- Data Validation Checklist for Excel: What to CheckA practical data validation checklist starts by defining what each field may contain, then applying the right Excel…
- Employee Schedule Template for Google Sheets: SetupAn employee schedule template in Google Sheets is a reusable spreadsheet for assigning shifts, tracking hours, and sharing…
- How to Close an Open Dialog Box in ExcelTo close an open dialog box in Excel for Microsoft 365 on Windows, press Esc, click the dialog’s…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.