Fill Right From Cell Left in Excel: How It Works

Updated 9 November 2026 · Standard formula, shown below

Yes. In Excel, “Fill Right” copies the contents or formula from the leftmost cell of a selected range into the cells to its right. Select the source cell and destination cells together, then use the Fill Right command or its keyboard shortcut; Excel adjusts relative formula references as it fills.

What Fill Right Does

Fill Right is a spreadsheet command for extending a value, formula, or pattern horizontally across a row. The leftmost selected cell is the source, and the other selected cells are destinations. The command fills those destinations from that source rather than moving the source cell.

For example, if A1 contains the label “January,” selecting A1:D1 and choosing Fill Right puts the same text in B1, C1, and D1. If A2 contains the formula =B2+C2, filling A2:D2 copies the formula across, changing the references in each destination when they are relative.

Despite its name, Fill Right does not automatically continue a series such as 1, 2, 3, 4. It repeats the source cell’s content, with formula references adjusted according to their reference types. Use the fill handle or a series command when you want Excel to infer a sequence.

How to Fill Right in Excel

To fill cells in a row, include both the source cell and every cell you want to fill in the selection. The source must be at the left edge of that selection. Then use one of these methods:

Keyboard shortcut: In desktop Excel for Windows, press Ctrl+R. On a Mac, the shortcut is commonly Control+R; keyboard mappings can vary by version and system settings.
Ribbon command: On the Home tab, choose Fill in the Editing group, then select Right. Ribbon layouts can differ slightly across Excel versions.
Context menu: Depending on the version and selection, right-clicking may expose fill-related commands. If Fill Right is not there, use the Home tab command.

A straightforward example is copying a heading in A1 across A1:E1. Select the full range A1:E1—not just B1:E1—then invoke Fill Right. Excel uses A1 as the source and fills B1 through E1. If the destination cells already contain information, filling replaces their contents, so check the selection before running the command.

What Happens to Formulas and References

Excel copies a formula’s structure and updates relative references based on how far the formula is moved. Suppose A1 contains =B1+C1. Filling A1 right into B1 produces =C1+D1; filling it into C1 produces =D1+E1. This behavior is useful for calculations repeated across months, products, or other columns.

Reference markers control what changes:

Relative reference: B1 changes in both column and row when copied to another location.
Absolute reference: $B$1 stays fixed when copied.
Mixed reference: $B1 fixes the column, while B$1 fixes the row.

For instance, if A2 contains =B2*$F$1, filling right shifts the relative reference B2 but keeps the tax rate or other constant in F1 fixed. Dollar signs in a reference are not currency formatting; they tell Excel which part of a reference to lock.

Fill Right Compared With Other Methods

Fill Right is not the same as dragging a cell’s fill handle. The command copies from the leftmost cell of the selected range to the right. The fill handle is the small square at the lower-right corner of a selected cell or range; dragging it can copy content or extend a recognizable series, depending on the data and the drag operation.

For a sequence, enter enough starting values to establish the pattern, select them together with the destination cells, and use the fill handle or a series-filling option. For example, entering 1 and 2 in adjacent cells and extending the selection can produce 3, 4, and 5. Fill Right alone would repeat the content of the leftmost cell instead of reliably creating that number series.

Copy and paste is another option when you need to copy a cell to a particular place or preserve a specific kind of content. Pasting can offer choices such as formulas, values, or formatting. Fill Right is more direct when the source is at the left edge and the destinations are in the same selected row.

Common Problems and Fixes

The wrong value is copied: Confirm that the source cell is the leftmost cell in the selection. A selection starting one column too far left can make Excel use an unintended source.
Nothing changes: Make sure the selection contains at least two cells and includes the intended source. If a worksheet is protected, editing restrictions may prevent changes.
A formula returns an unexpected result: Inspect its references after filling. Relative references move; add dollar signs to references that must stay fixed.
Existing data disappears: Fill Right overwrites destination contents. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac if the result was unintended.
A series is repeated instead of extended: That is expected for Fill Right. Use a fill handle or series feature when the goal is a sequence rather than a copy.

One common misconception is that “right” means the command fills from the active cell, wherever it sits in the selection. The reliable rule is that Excel takes the leftmost cell of the selected range as the source. If the desired source is in the middle, arrange the selection or copy and paste in a way that makes the intended source explicit.

When Fill Right Is Useful

Fill Right is handy when a row contains repeated labels, formulas, or formatting. A budget might calculate monthly totals in the first month column, then fill the formula across later months. A schedule can repeat a heading, while a report can extend formulas that refer to each column’s data.

Before filling a large range, test the command across a few cells and inspect the results. This is especially useful for formulas involving mixed references, blank cells, or cells whose contents are important. Because the command copies the source across all selected destinations, selecting an entire row accidentally can overwrite far more than intended.

Frequently Asked Questions

What is the shortcut for Fill Right in Excel?
In desktop Excel for Windows, use Ctrl+R after selecting a range that starts with the source cell. On Mac, Control+R is commonly used, though shortcuts may vary with the application and system configuration.

Does Fill Right copy formatting too?
It fills the selected cells from the leftmost cell, which can include cell contents and formatting. If you need to control whether formulas, values, or formats are copied, use copy and paste options instead.

Can I fill right without changing formula references?
Yes. Make the references absolute with dollar signs, such as $B$2. You can also use mixed references to lock only the row or column that should remain fixed.

Why does Fill Right repeat a number instead of counting up?
Fill Right copies the source cell; it is not a general series-generation command. Use the fill handle or a series option to extend a numeric sequence.

Can I use Fill Right in Excel for the web?
Excel for the web supports spreadsheet filling, but available commands and shortcuts can differ from desktop Excel. If the shortcut does not work, look for the Fill command on the Home ribbon or use the fill handle.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.