In Excel for Microsoft 365 on Windows, select the cells to fill, including the source cell at the top, then press Ctrl+D to fill down. To repeat the leftmost cell across a selection, press Ctrl+R to fill right.
What Ctrl+D Does in Excel
Ctrl+D is Excel’s Fill Down shortcut. It takes the contents and formatting of the top row in the selected range and copies them into the rows below. Include the source cell in your selection: if you want a formula from C2 copied through C20, select C2:C20 before pressing Ctrl+D. Selecting only C3:C20 leaves Excel without the intended top-row source.
The shortcut copies rather than creates a pattern. If the source cell contains the number 5, the filled cells will contain 5, not 6, 7, and so on. If the source contains a formula, Excel copies it and adjusts relative references in the destination cells, much as it would when you copy and paste the formula.
For example, suppose B2 contains a product price and C2 contains a tax rate, while D2 has a formula that calculates the total. Select D2:D10 and press Ctrl+D to copy the formula down. If the formula refers to B2 and C2 with ordinary relative references, the copies will refer to B3 and C3, then B4 and C4, and so on. Absolute references, such as $C$2, stay fixed when copied.
How to Fill Down Step by Step
- Enter the value, formula, or formatting you want to repeat in the top cell of the intended range.
- Select that cell and the destination cells beneath it. You can drag over the range or click the first cell, hold Shift, and click the last cell.
- Press Ctrl+D. Excel fills the selected cells from the top row.
- Check a few filled cells, especially when formulas include relative or absolute references.
You can also use the ribbon instead of the keyboard: choose Home > Fill > Down. This is useful if you cannot remember the shortcut or are working on a device where the keyboard combination is inconvenient. The ribbon command applies the same fill-down behavior to the current selection.
For a large range, selecting the destination can be quicker through the Name Box, the small box to the left of the formula bar. If the source is A2 and you want to fill through A500, type A2:A500 in the Name Box, press Enter, and then use Ctrl+D. Make sure the selected range starts with the cell that should supply the content.
How to Fill Right with Ctrl+R
Ctrl+R is the horizontal counterpart. Select the source cell on the left and the cells to its right, then press Ctrl+R. Excel copies the leftmost cell across the selected range. The matching ribbon command is Home > Fill > Right.
For instance, if January’s calculation is in B5 and the same kind of calculation is needed for February through June, select B5:G5 and press Ctrl+R. Relative column references shift as the formula is copied to the right. If the source formula refers to a fixed assumption in $A$1, that reference remains locked.
Ctrl+R is not the same as copying a cell with Ctrl+C and pasting it repeatedly, although both can duplicate content. Fill Right works directly across the selected range and is convenient when the leftmost cell is the established example. Likewise, Ctrl+D is often faster than copying a formula cell and pasting into a long vertical range.
Fill Down Is Not the Same as Creating a Series
A frequent surprise is that Ctrl+D repeats the source; it does not continue a sequence. If A1 contains 1, selecting A1:A5 and pressing Ctrl+D puts 1 in every selected cell. To make 1, 2, 3, 4, 5, use a series-filling method instead.
One option is to enter the first two values, select both, and drag the fill handle—the small square at the lower-right corner of the selection—down or across. Excel can use the interval between the two values to extend a pattern. For example, starting with 2 and 4 can produce 6, 8, and 10. With dates, two starting dates can establish a daily, weekly, or other interval. A single starting value may instead be copied, depending on the type of data and the fill action.
For a controlled numeric series, use Home > Fill > Series. The Series dialog lets you specify whether the sequence runs in rows or columns, its step value, and an optional stop value. This is preferable when you need a precise increment, such as adding 10 to each number, or when you want the sequence to stop at a defined limit. After dragging the fill handle, the Auto Fill Options button may also offer choices such as copying cells or filling a series, depending on the selection.
Choosing the Right Fill Method
Use the method that matches the result you want, rather than assuming every fill command extends a pattern:
- Repeat a value, formula, or format down a range: select the source at the top and press Ctrl+D.
- Repeat content from left to right: select the leftmost source and press Ctrl+R.
- Continue a number or date pattern: use the fill handle with enough starting examples, or choose Home > Fill > Series.
- Enter one item in several selected cells: select the cells, type the entry, and press Ctrl+Enter. This is a different operation from Fill Down; it enters the current entry throughout the selection.
- Complete a recognizable text pattern: consider Flash Fill with Ctrl+E, which detects patterns in adjacent data. Flash Fill is not the same as copying a formula and may need a clear example to infer the intended transformation.
For example, if a column contains full names and you want first names in a neighboring column, Flash Fill may identify the pattern after you enter one or two examples. If you need a calculation that updates when the source data changes, use a formula instead. Fill Down copies a formula; Flash Fill produces text values based on its detected pattern.
Formulas, Formatting, and Reference Behavior
Fill Down and Fill Right copy more than the displayed result. They can copy the formula and cell formatting from the source, so a destination may inherit number formats, font styling, borders, or shading. This is helpful when extending a consistently formatted table, but it can also create unwanted formatting if the source cell has special styling.
Formula references determine whether the copied calculations behave as intended. A relative reference such as A2 changes position as a formula is filled. An absolute reference such as $A$2 stays fixed. A mixed reference locks just one part: $A2 keeps the column fixed while the row can change, and A$2 keeps the row fixed while the column can change. The F4 key cycles reference styles while editing a formula on Windows.
Before filling a long range, inspect the source formula and decide which references should move. For example, a commission formula may need to multiply each row’s sales by one fixed rate. The sales reference should usually move down, while the rate reference should be absolute. If the rate is in F1 and sales are in E2, a formula can use =E2*$F$1. Filling it down adjusts E2 to E3, E4, and so forth, while $F$1 remains unchanged.
Common Problems and How to Fix Them
- Nothing changes: confirm that the selection includes at least two cells and that the source is at the top for Ctrl+D or at the left for Ctrl+R.
- The same number appears repeatedly: that is expected for Fill Down. Use the fill handle or the Series command to extend a numerical sequence.
- Formulas return unexpected results: check whether references should be relative, absolute, or mixed. A missing dollar sign can cause a reference to shift; an unnecessary dollar sign can prevent it from shifting.
- Formatting changes unexpectedly: the fill operation copies source formatting. Consider applying the desired format afterward, or use a paste option that pastes formulas or values only when that better suits the task.
- The shortcut triggers another action: check which application has focus, whether a cell is being edited, and whether a laptop function-key or system setting is intercepting the key combination. You can use Home > Fill as an alternative.
When a range contains filtered or hidden rows, do not assume a fill will affect only the visible records in the way you intend. Check the selection and resulting cells before relying on it for a filtered list. For important worksheets, filling a small test range first can reveal whether formulas and formatting behave as expected.
Windows, Mac, and Excel for the Web
The shortcuts in this guide are for Excel for Microsoft 365 on Windows. In Excel for Mac, the corresponding fill shortcuts are generally Control+D for Fill Down and Control+R for Fill Right; Mac uses the Control key for these particular commands, not the Command key. If a shortcut conflicts with a macOS setting or keyboard configuration, use the Home tab’s Fill menu.
Excel for the web may handle keyboard combinations differently depending on the browser and operating system, and some shortcuts can be intercepted by the browser. The ribbon provides a dependable alternative: select the range and choose Home > Fill > Down or Home > Fill > Right. If you use a version other than Microsoft 365, the ribbon layout or availability of particular options may vary, but Fill Down and Fill Right are longstanding Excel commands.
Frequently Asked Questions
What is the shortcut to fill down in Excel?
On Windows, select the range including the source cell at the top and press Ctrl+D. Excel copies the top row into the cells below.
What is the shortcut to fill right in Excel?
Select the source cell at the left and the destination cells to its right, then press Ctrl+R on Windows. The leftmost cell supplies the content.
Does Ctrl+D continue a number sequence?
No. It copies the top cell’s contents down, so a single number is repeated. Use the fill handle or Home > Fill > Series to create a sequence with an increment.
Can I use Fill Down for formulas?
Yes. Select the formula cell and the cells beneath it, then press Ctrl+D. Excel adjusts relative references as the formula is copied, while absolute references remain fixed.
What is the fill shortcut on a Mac?
Excel for Mac generally uses Control+D to fill down and Control+R to fill right. These commands use Control rather than Command; the ribbon’s Home > Fill menu is an alternative.
How do I fill selected cells with the same entry?
Select the cells, type the value or formula, and press Ctrl+Enter on Windows. That enters the current entry in the selection; it is not the same as copying the top cell with Ctrl+D.
Related
- Excel Ordinal Number Format: Show 1st, 2nd, and 3rd
- Excel or Word for a Checklist? Compare the Best Fit for You
- Excel Order List Template: How to Build and Use One
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- DAX Formula in Excel: How It Works and ExamplesA DAX formula in Excel is an expression used in the Excel Data Model to create a measure…
- Excel SUM Without Hidden Cells: Which Formula to UseTo sum only visible rows in Excel, use SUBTOTAL with function number 109. With amounts in B2:B6 and…
- Excel Formula for Adding Hours on a Timesheet CorrectlyTo add timesheet hours in Excel, use =SUM(B2:B8) when the daily durations are in cells B2 through B8.…
- Excel Data Analysis Cheat Sheet: Formulas and ToolsAn Excel data analysis cheat sheet is a quick guide to preparing data, summarizing it with formulas or…
- Excel FILTER Function: Find Rows Using Partial TextYes. In Excel for Microsoft 365, FILTER can return rows whose text contains a word or phrase by…
- Excel Power Query Left Function: How to Extract TextIn Excel Power Query, the equivalent of the worksheet LEFT function is Text.Start(text, count): it returns the first…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.