Document Editing Problems

Fix Excel Fill Right or Ctrl+R Copying the Wrong Cell

Ayan MasoodAyan Masood Nov 10, 2026 868 views

Question details

The user needs to fix an issue where the Fill Right command or the Ctrl+R shortcut in Excel copies the wrong cell instead of the leftmost cell in the selection.

Fix Excel Fill Right or Ctrl+R Copying the Wrong Cell
Product
Microsoft Excel
Device & OS
not provided
Scenario
Attempting to copy a value across a horizontal range using the Fill Right feature or its designated keyboard shortcut.
Observed behavior
Excel copies a value from the right or copies an entirely incorrect cell, failing to duplicate the leftmost source cell across the selected destination cells.
Before you start

Make sure your keyboard is not experiencing stuck keys (such as a stuck Shift or Alt key) and verify that you are working on a standard, unprotected worksheet without active macros that might override default shortcuts.

Solution 1Recommended

Use the Correct Range Selection Sequence

The most common cause of Fill Right errors is an incorrect cell selection sequence. Excel requires the source cell to be precisely at the left edge of the highlighted range.

The Fill Right (Ctrl+R) command relies on the active cell position within your selection. If the active cell is at the right edge instead of the left, Excel might attempt to fill data in reverse or pull blank data.

1
Select the source cell

Click exactly on the leftmost cell containing the value, text, or formula you want to copy.

2
Highlight the destination range

Hold down the left mouse button and drag your cursor to the right to select all the empty cells where you want the copied value to appear.

3
Apply Fill Right

Press Ctrl+R on your keyboard. Alternatively, go to the Home tab, click the Fill icon in the Editing group, and choose Right.

Use the Correct Range Selection Sequence
Alternative Method: You can bypass selection sequence errors by simply clicking the source cell, grabbing the small green square (Fill Handle) at its bottom-right corner, and dragging it to the right.
Efficient Spreadsheet Editing

Easily Fill Data Across Cells with WPS Spreadsheet

WPS Office provides a highly compatible and user-friendly spreadsheet editor. The Fill Right feature and its Ctrl+R shortcut work seamlessly right out of the box, avoiding unexpected key mapping conflicts while handling complex datasets effortlessly.

  1. 1. Open your file: Launch WPS Spreadsheet and open your existing Excel workbook.
  2. 2. Select the target range: Click the leftmost cell containing your data, then drag to select the adjacent blank cells to its right.
  3. 3. Execute the fill command: Press Ctrl+R on your keyboard to instantly and accurately fill the data across the selected range.
100% compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsFlawless native support for all standard keyboard shortcuts including Ctrl+RFree, lightweight, and fast to launch without heavy background processesBuilt-in intuitive cell formatting, data filling, and drag-and-drop tools
microsoft office alternative - wps office

Frequently Asked Questions

Why does Ctrl+D work perfectly but Ctrl+R does not?

Ctrl+D fills data down from the top cell, while Ctrl+R fills right from the leftmost cell. If Ctrl+R fails while Ctrl+D works, the horizontal selection might be inverted (selected right-to-left instead of left-to-right), or a third-party application on your computer might be hijacking the Ctrl+R shortcut for another function, such as refreshing a web browser.

Can I change or remap the Fill Right shortcut in Excel?

Microsoft Excel does not have a native user interface for changing default keyboard shortcuts. If you need to remap the Fill Right command to a different key combination, you would have to write a custom VBA macro or use a third-party keyboard remapping tool.

How do I fill right without using a keyboard shortcut?

You can use the ribbon menu by selecting your horizontal range, navigating to the Home tab, locating the Editing group, clicking the Fill icon (which looks like a blue downward arrow), and selecting 'Right'. Alternatively, you can use your mouse to drag the fill handle (the small square at the bottom right corner of the active cell) horizontally across the blank cells.