Copy Across Shortcut

In the structure below let’s assume you want to copy the SUM formula from cell B5 to cell C5.

Obviously you could use copy and paste, but that would require a few keyboard presses or mouse clicks.

Given that we already have cell C5 selected we can use

Ctrl + Shift + >

This copies whatever is in the cell on the left to the current cell.



Adversity is the state in which man most easily becomes acquainted with himself, being especially free of admirers then.

Samuel Johnson (1709-1784)