Fix Excel Fill Right or Ctrl+R Copying the Wrong Cell
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.

- 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.
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.
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.
Click exactly on the leftmost cell containing the value, text, or formula you want to copy.
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.
Press Ctrl+R on your keyboard. Alternatively, go to the Home tab, click the Fill icon in the Editing group, and choose Right.

Check Worksheet Protection and Merged Cells
Protected sheets or improperly merged cells can block or disrupt normal data fill operations.
Troubleshoot Keyboard Shortcuts and Add-ins
Third-party add-ins or background software might hijack or reassign the Ctrl+R shortcut, causing unexpected behavior.
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. Open your file: Launch WPS Spreadsheet and open your existing Excel workbook.
- 2. Select the target range: Click the leftmost cell containing your data, then drag to select the adjacent blank cells to its right.
- 3. Execute the fill command: Press Ctrl+R on your keyboard to instantly and accurately fill the data across the selected range.

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.




