Excel Cell Fill Shortcut: Fill Down, Fill Right, and Color

In Excel for Microsoft 365 on Windows, press Ctrl+D to fill down from the top cell of a selection, or Ctrl+R to fill right from its leftmost cell. If by “fill” you mean cell background color, press Alt, H, H in sequence to open the Fill Color palette; it is a different command.

What the Excel fill shortcuts do

Excel uses “fill” for more than one task, which is why a search for a cell fill shortcut can lead to different answers. Ctrl+D and Ctrl+R copy the contents of a source cell through a selected range. They are useful for repeating a value, duplicating a formula pattern, or carrying formatting into adjacent cells. They do not open the background-color palette.

The direction and source cell matter:

Ctrl+D — Fill Down: uses the top cell in the selected range as the source and fills the cells beneath it.
Ctrl+R — Fill Right: uses the leftmost cell in the selected range as the source and fills the cells to its right.
Alt, H, H — Fill Color: opens the color menu so you can choose a cell background color.

These are Windows desktop shortcuts. On a Mac, Excel also uses Control+D and Control+R for Fill Down and Fill Right; these commands use the Control key rather than the Command key. The ribbon commands are useful if you are unsure which meaning of fill you need.

How to fill cells down with Ctrl+D

To copy a cell down a column, include both the source cell and the destination cells in your selection. For example, if A2 contains the label North and you want the same label in A3 through A6, select A2:A6 and press Ctrl+D. Excel copies the top cell into the cells below it. Selecting only A3:A6 would make A3 the source instead, so the intended source must be the first cell in the selection.

Enter or locate the value, formula, or formatting in the top cell.
Select that cell together with the cells below that should receive the fill.
Press Ctrl+D on Windows, or Control+D in Excel for Mac.
Check the filled cells, especially if the source contains a formula or has distinctive formatting.

You can also use the ribbon: choose Home > Editing > Fill > Down. This is handy when working on a device where the keyboard shortcut is intercepted or when you want to see the command’s direction before applying it. A blank source cell is still a source: filling from it can clear existing contents in the destination cells, so check the top cell before using the shortcut on a populated range.

How to fill cells right with Ctrl+R

Fill Right works on the same principle, but takes its source from the left edge of the selection. Suppose B1 contains the heading Q1 and you want it repeated through E1. Select B1:E1 and press Ctrl+R. Excel copies the contents and applicable formatting from B1 across the selected row. If you select C1:E1 instead, C1 becomes the source.

The ribbon equivalent is Home > Editing > Fill > Right. Fill Right is useful for repeating a label across a report, extending a row of formulas, or applying the same number format across adjacent cells. It is not the same as copying and pasting into an arbitrary set of nonadjacent cells: the selected destination range needs to extend from the source in the appropriate direction.

What happens to formulas and formatting

When the source contains a formula, filling usually copies the formula pattern, not simply the displayed result. Excel adjusts relative cell references to match each destination row or column. For example, if a formula in D2 refers to cells in row 2, filling it down to D3 normally changes those relative references to row 3. This is often exactly what a calculation column needs.

References marked as absolute with dollar signs remain fixed when a formula is filled. Mixed references lock either the row or the column, depending on where the dollar sign appears. That distinction matters when extending calculations across both rows and columns: a reference intended to move may need to be relative, while a constant or fixed lookup location may need to be absolute. If results look unexpectedly identical or point to the wrong cells, inspect the references in the first filled formula.

Fill commands generally copy the source cell’s contents and formatting, including number formats and visual styling. Consequently, filling a formula can also copy a border or background color that you did not intend to repeat. If you only want the formula or value, use the Fill options available from the ribbon or the paste options that appear after copying, and choose an option that excludes formatting where available. Check the result rather than assuming that the command changes contents alone.

How to use the Fill Color shortcut

If “cell fill” means a background color, use the Fill Color control rather than Ctrl+D or Ctrl+R. On Windows desktop Excel, press Alt, then H, then H. These are sequential key-tip presses, not a single three-key combination. Excel opens the Fill Color palette; use the arrow keys to move among available colors and press Enter to apply the highlighted choice. You can also click the paint-bucket icon on the Home tab and select a color.

To color several cells at once, select the range first and then open the palette. The chosen color is applied to the selected cells. The palette includes theme and standard colors, and its available choices can depend on the workbook’s theme. If you need a specific custom shade, open the color options and use the custom-color controls rather than assuming that one fixed keyboard sequence will select it.

Excel for Mac does not use the same Windows Alt-based ribbon key-tip sequence. On a Mac, select the cells and use Home > Fill Color to choose the background. Excel for the web also has a Fill Color control on the Home tab; browser and keyboard behavior can differ, so the ribbon is a dependable alternative when a shortcut does not respond as expected.

Other ways to repeat or extend data

Ctrl+D and Ctrl+R are best when you know the exact source cell and destination range. Other Excel tools suit different jobs:

Drag the fill handle: drag the small square at the lower-right corner of a selected cell or range to copy or extend content. Depending on the starting data, Excel may continue a series rather than repeat one value. The Auto Fill Options button can offer choices such as copying cells or filling a series.
Home > Editing > Fill > Series: use the Series command when you want a controlled sequence, such as a numerical or date series, rather than a straight copy.
Ctrl+Enter: after selecting a range and typing a value, press Ctrl+Enter on Windows to enter that same value in every selected cell. This is useful for filling a block at once without copying from a source cell.
Ctrl+E, Flash Fill: on Windows, Flash Fill can infer a pattern from examples, such as separating parts of names into another column. It is pattern recognition, not the same as Fill Down, and its result should be checked for inconsistent source data.

These options are not interchangeable. A fill handle may extend a sequence, while Ctrl+D repeats the source cell’s contents down the selected range. Ctrl+Enter puts the typed entry into all selected cells, and Flash Fill generates values based on a detected pattern. Choosing the right tool helps avoid accidentally creating a series or copying a value where a formula is needed.

Common problems and quick checks

If Ctrl+D or Ctrl+R appears to do nothing, first confirm that the selection includes the source cell and at least one destination cell. For Fill Down, the source must be at the top; for Fill Right, it must be at the left. Also check that Excel, rather than another window or a browser control, has focus. In Excel for the web, a browser may reserve a familiar keyboard shortcut, so use the Home tab’s Fill command if the keystroke is intercepted.

If the wrong value or formula was copied, undo immediately with Ctrl+Z on Windows, or Command+Z on Mac, then select the range again with the correct source at its edge. Undo is especially important if a blank source overwrote existing data. If the fill also changed borders, colors, or number formats, look for a fill or paste option that preserves the desired content while leaving the destination formatting unchanged.

A shortcut can also appear to produce repeated results when it is working correctly: the displayed values may match even though formulas adjust by row or column. Click a filled cell and inspect the formula bar to see whether its references shifted as intended. Conversely, if every cell should show the same fixed reference, make sure that reference is locked appropriately before filling.

Frequently Asked Questions

What is the shortcut to fill down in Excel?

On Windows, select the source cell and the cells below it, then press Ctrl+D. In Excel for Mac, use Control+D. The top cell of the selection supplies the content and formatting for the cells underneath.

What is the shortcut to fill right in Excel?

Select the source cell and the cells to its right, then press Ctrl+R on Windows. Excel for Mac uses Control+R. The leftmost selected cell is the source, so include it in the selection.

How do I fill a cell with color using the keyboard?

In Windows desktop Excel, press Alt, H, H in sequence to open the Fill Color palette. Choose a color with the keyboard or click one. On Mac or the web, use Home > Fill Color if the Windows key-tip sequence is unavailable.

Does Ctrl+D copy formulas or just values?

It fills from the source cell, including its formula when it has one. Relative references normally adjust for the destination row, while absolute references stay fixed. The command can also copy formatting, so check both the formula and appearance after filling.

How do I put the same value in many selected cells?

Select all the destination cells, type the value, and press Ctrl+Enter on Windows. Excel enters the typed value throughout the selection. This differs from Ctrl+D because it does not require a separate top source cell.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.