Exceljet

Quick, clean, and to the point

Fill right from cell left

Windows shortcut 
CtrlR
Mac shortcut 
R

This shortcut will copy from left to right. For adjacent cells, select one or more cells directly to the right of the data you want to copy and use the shortcut. For non-contiguous cells, select both source and target cells, then use the shortcut. This shortcut is especially handy in filtered lists, since it works with visible cells only.

Related videos

The videos below demonstrate this shortcut.
In this lesson, we cover shortcuts you can use to to enter data in one or more cells at a time. Knowing these tips can really speed up editing in Excel.