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)

Our grand business in life is not to see what lies dimly at a distance, but to do what lies clearly at hand.

Thomas Carlyle (1795-1881)

 

Old Article

Some articles make a greater impression than others. I was recently asked about a magazine article from August 2011.

Someone had changed jobs and needed to be reminded of the rolling 13 month technique.

The congratulations relate to 15 years of Excel Yourself!