Excel Ctrl+D and Ctrl+R Shortcuts: Copy Down and Copy Right in One Keystroke

You need to copy a formula or value to many cells below or to the right. Manually dragging the fill handle or copying and pasting is slow and inefficient. Excel provides dedicated keyboard shortcuts to fill data instantly. This article explains how to use Ctrl+D to copy down and Ctrl+R to copy right.

How the Fill Down and Fill Right Shortcuts Work

The Ctrl+D and Ctrl+R shortcuts are designed for speed. They replicate the action of using the Fill Handle but with your keyboard. These commands copy everything from the source cell: its value, formula, formatting, and data validation rules. The source cell is determined by your selection. For Ctrl+D, the source is the topmost cell in your selected range. For Ctrl+R, the source is the leftmost cell. The shortcuts require a specific cell selection pattern to function correctly.

Prerequisites for Using the Shortcuts

Your data must be in a contiguous block of cells. You cannot use these shortcuts on non-adjacent cells selected with the Ctrl key. The source cell you want to copy from must be included in the selection. The shortcuts will not work if you only select the destination cells. They are ideal for filling a column with the same formula or copying a header label across several rows.

Steps to Use Ctrl+D and Ctrl+R

Follow these steps to copy data down a column or across a row instantly.

Using Ctrl+D to Fill Down

1. Select the source and target cells
   Click on the cell containing the data you want to copy. While holding the Shift key, press the Down Arrow key to select all the cells below it that you want to fill. The original cell must remain the top cell in the selected range.
2. Press Ctrl+D
   With the range selected, press and hold the Ctrl key, then press the D key. Excel immediately copies the content from the top cell into every other selected cell in the column.
3. Verify the fill
   Check that the data or formula has been copied correctly. If you filled a formula, ensure cell references have adjusted as you intended, based on using relative or absolute references.

Using Ctrl+R to Fill Right

1. Select the source and target cells
   Click on the cell with the data to copy. While holding the Shift key, press the Right Arrow key to select all the cells to the right that you want to fill. The original cell must be the leftmost cell in your selection.
2. Press Ctrl+R
   With the range selected, press and hold the Ctrl key, then press the R key. Excel copies the content from the leftmost cell into every other selected cell in the row.
3. Check the results
   Look at the filled cells to confirm the copy was successful. This is especially important when copying formulas that reference other columns.

Common Mistakes and Limitations

These shortcuts are powerful but have specific rules. Avoid these common errors.

Shortcut Does Nothing

If pressing Ctrl+D or Ctrl+R has no effect, you likely have not selected the cells correctly. You must select a block that includes both the source cell and the destination cells. Selecting only the destination cells will not work. Also, ensure you are not in Edit mode (where the cursor is blinking in the formula bar); these shortcuts only work from Ready mode.

Formulas Copy Incorrectly

The shortcuts copy formulas exactly as the standard fill handle does. If your formula uses relative references like A1, it will adjust for each row or column you fill. If you need the reference to stay fixed on one cell, you must use absolute references like $A$1 before using the shortcut. Check a few filled cells to see if the formula references point where you expect.

Formatting Overwrites Destination Cells

Ctrl+D and Ctrl+R copy all cell properties, including number format, font color, and borders. This will overwrite any existing formatting in the destination cells. If you only want to copy the value or formula without formatting, use Paste Special after a standard copy operation instead.

Ctrl+D vs. Ctrl+R vs. Fill Handle: Key Differences

Item	Ctrl+D (Fill Down)	Ctrl+R (Fill Right)	Mouse Drag (Fill Handle)
Primary Action	Copies top cell down a column	Copies left cell across a row	Copies in any direction
Best For	Filling long columns quickly	Filling wide rows quickly	Small ranges or complex series
Selection Required	Contiguous vertical range	Contiguous horizontal range	Single cell or range edge
Speed	Fastest for vertical fill	Fastest for horizontal fill	Slower, requires mouse precision
Copies Formatting	Yes	Yes	Yes

You can now fill data vertically or horizontally without touching your mouse. Use Ctrl+D to copy formulas down a report column and Ctrl+R to copy headers across a summary row. For more control, try the Ctrl+Enter shortcut to fill a selected range with the same data. Remember that F4 repeats your last action, which can be another fast way to apply a recent fill.