Fill Right in Excel
The Fill Right shortcut copies the content or formula of the active cell to the selected cells on the right. This is helpful for quickly propagating data or formulas across a row.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + R | Cmd + R |
What Does This Shortcut Do?
Pressing this shortcut fills the selected cells to the right of the active cell with the same content or formula as the active cell. Formulas are adjusted relative to their positions.
How to Use the Shortcut
- Select the cell containing the data or formula you want to copy
- Select the range of cells to the right to fill
- Press Ctrl + R (Windows) or Cmd + R (Mac)
- The active cell’s content or formula will be copied to the selected cells
Tips & Best Practices
- Works for text, numbers, and formulas
- Useful for quickly filling large rows or Excel tables
- Check formula references to ensure correct results when filling across
FAQ
- Q: Will this overwrite existing data?
- Yes, the selected cells on the right of the active cell will be overwritten.
- Q: Can I fill right multiple rows at once?
- No, Ctrl + R only fills to the right within the same row.