Fill Right From Cell Left

Using the Fill Right From Cell Left Shortcut

Windows keyboard shortcut

 
Mac keyboard shortcut

This Excel shortcut copies data from left to right. If cells are next to each other simply select one or more cells to the right of the data you want to copy before using the shortcut. If cells are non-contiguous, select the source cell and target cells then use the shortcut.

This shortcut will only work with visible cells.
Other useful Entering Data keyboard shortcuts