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...

Comments

  1. AbinOctober 3, 2009 at 11:41 AM

    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. ArvindOctober 4, 2009 at 7:13 AM

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

    ReplyDelete
  3. Bankrupcy discharge papersOctober 2, 2010 at 2:02 PM

    Arvind:

    I will say memorable steps to use Ctrl+D.

    Thanks for efforts and posting.

    Dyana

    ReplyDelete
  4. n@aveenOctober 24, 2011 at 9:22 PM

    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
  5. AnonymousNovember 1, 2013 at 12:11 PM

    thank youuu

    ReplyDelete
  6. the best proofreader is online for youMarch 17, 2018 at 3:46 AM

    I like working excel. That is the programme that helps me to make good projects and grids.

    ReplyDelete

Post a Comment

Popular posts from this blog

Keyboard Shortcut to add/delete rows or columns in Excel

Image
" Ctrl + + " (add rows or columns) and " Ctrl + - " (delete rows or columns) are the easy shortcuts one may remember while adding and deleting rows/columns in Microsoft Excel. Adding rows or columns: If you wish to add rows above the current cell... just press "shift + spacebar" (discussed in my earlier post) to select the current row and then press "Ctrl + +". It will insert a row over the current row. Press "Ctrl + +" repeatedly to insert as many rows. Similarly, "ctrl + spacebar" and then "Ctrl + +" adds a column before the current column. You may try pressing "Ctrl + +" without selecting a row or a column. In such a case, you may get a pop-up (as shown in the image) where you can choose an option of adding a row or a column. Deleting rows or columns: "shift + spacebar" followed by "Ctrl + -" deletes the selected row & "ctrl + spacebar" followed by "Ct...
Read more

Excel Keyboard Shortcuts - Handy during day to day work

I've had few posts earlier on few excel shortcuts. Navigation powered by "Ctrl" in Excel Shortcut to insert current date in a cell Shortcut to AutoFilter So, here I am, back with some more interesting shortcuts which will make your excel spreadsheet experience simpler. Let me start with some "CTRL" combinations which will be very handy for formating cells to match your requirements: CTRL + 1 : Opens the "Format Cells" dialog box CTRL + 2 : is to make the contents of the cell BOLD (this is a toggle key, to unbold use same CTRL + 2) CTRL + 3 : is to make the contents of the cell ITALICS (this is a toggle key) CTRL + 4 : is to underline the contents of the cell (this is a toggle key) CTRL + 5 : is to strike through the contents of the cell (this is a toggle key) CTRL + 9 : is to hide the entire row (to unhide use SHIFT + CTRL + 9) CTRL + 0 : is the hide the entire column (to unhide use SHIFT + CTRL + 0) CTRL + ~ : is to show or...
Read more

Alternative for SUMIF and SUMIFS - Part 2 (SUMPRODUCT)

Image
We already know the primary challenge of using SUMIF or SUMIFS i.e. unable to sum more than a single column or row as a sum range. Many of us in the course of our excel usage may have experienced that SUMIFS has a bigger disadvantage when used across workbooks i.e. the source workbook should be open inorder to enable to computation in the destination workbook. If the source workbook remains closed, the result in the destination workbook will be "#VALUE". In my previous post , the alternative suggested not only does overcome the  "#VALUE" challenge but also allow users to sum a larger range.  In this post, I was able to decipher yet another alternative. I'm sure expert users may already be using this however to help other users, this post can be a ray of hope. We may have used the SUMPRODUCT function to calculate weighted average. Extrapolating the usage of SUMPRODUCT with condition or conditions can help you achieve the SUMIFS goal.  Syntax:  =SU...
Read more