Saturday, October 3, 2009

Shortcut to Copy the contents of the cell above or on the left

Most of us may have not tried this. We are very much familiar with the world-famous "Ctrl + C" and "Ctrl + V" but have you tried "Ctrl + D" and "Ctrl + R" in excel??


"Ctrl + D" offers the flexibility of copying the content of the cell above to the next cell or a range of cell below. Here you just need to use one action instead of the regular copy and paste.




For example: 
If you have A1 with some content and you wish to copy the same content to A2, just go to A2 and press "Ctrl + D". The content of A1 gets copied to A2 in one just one command.


If you wish to copy the contents of A1 to a range of cells below A1 (say A2 to A10), select A1 to A10 (as shown in the image on the right) and press "Ctrl + D"... then see the magic!!


"Ctrl + R" also offers a similar functionality. Using this you can copy the contents to the right cells i.e. if you wish to copy the contents of A1 to B1. The process is same as "Ctrl + D"..!!


Isn't this time saving?? So why wait .... start using it and let me know if you find this helpful!!!...


In case you too have some shortcuts to share, just mail me at email@arvindkumar.com...

6 comments:

  1. Good stuff Arvind.
    Like to add a short cut for selection to different excel worksheets: To move from Sheet 1 to sheet 2 or 3 just press Ctrl+pg dn and to go back to Sheet1 press Ctrl+pg up. This is a very easy way of to & fro between different worksheets. Hope this is helpful. Cheers.

    ReplyDelete
  2. Yes... a very handy and popular shortcut..!! Thanks Abin!

    ReplyDelete
  3. Arvind:

    I will say memorable steps to use Ctrl+D.

    Thanks for efforts and posting.

    Dyana

    ReplyDelete
  4. I NEED SHORT CUT FOR THE COPY
    IF THE DATA IS AVALIBE IN C2 CELL THE DATA CAN BE COPY TO C4 CELL WAT IS THE SHORT CUT FOR THAT PLC TELL ME
    MY PHONE NUM IS 7842118912

    ReplyDelete