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.
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...
2 click here to comment:
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.
Yes... a very handy and popular shortcut..!! Thanks Abin!
Post a Comment