This article shows the magic of Shift and Control keys and how we can use them with arrow keys to work faster.
If you have a lengthy data and you wish to drag a formula in a particular cell down to the end of the data then instead of using shift and down arrow to copy the formula, you can use excel’s auto-fill function. When you move the cursor to the bottom right hand corner of the cell, you would see a small square. When you double click on it, your formula would automatically get copied down to the last cell of the adjacent left column.
However, this method would not work when the adjacent left cell is blank. In that case the easiest and fastest method is to copy the cell that has the formula and then just go to any column which is non-empty and which has entries to the end of the data and hit control+ down arrow, that way you would reach to the end and now using left or right key go to the column which you want to fill up and hit shift+control+up arrow key, followed by the enter key. And it will be done in no time.
For e.g. you have entries in column A but column B is empty. And you have some formula in cell C1 which you want to drag down to the end. So simply copy cell C1, using the left arrow key go to cell A1, reach the end of the data using control+down arrow key. Then go right using the right arrow key to reach column C. Then holding down the shift and control key hit the up arrow key which will take you to cell C1 and just hit ENTER.