Excel Ctrl + D & Ctrl + R: Keyboard Shortcuts for Your Daily Workflow

July 18, 2012 Excel  No comments

Are you learning to love keyboard shortcuts as much as we are? Glued to your mouse and want to know how to accomplish additional functions without it? Either way, these shortcuts are very helpful.

In this tutorial, you will learn how to use two different keyboard shortcuts in a couple of ways. These are very helpful when you need to fill many cells with identical data. Read on! If you have any questions, as always, feel free to email us at questions@pbttinfo.com.

* * * * *

1. CTRL + D is a keyboard shortcut that fills down the information in the cell above. Let’s look at an example. Below, we want to change the cell containing the word “Invoice” to “Allocated,” like the cell above it:

2. Now, press CTRL + D on your keyboard, and you should see the following change:

3. CTRL + D is useful because, as you can see below, using Autofill to drag the date down to the next cell will actually change the date to the following day, whereas using CTRL + D will fill down the identical date (or any contents) from the cell above.

4. You can do the same function horizontally; that is, pressing CTRL + R will fill right. In addition, with both CTRL + D and CTRL + R, you can highlight cells in a column or row, respectively, that you want to fill with the original selected cell, as shown below…

5. … and now, pressing CTRL + R in this case will fill all of the highlighted cells with the contents of cell H4:

If you have any question or suggestion, feel free to comment or email us at questions@pbttinfo.com

See you soon for the next trick!

Vince – Desktop Training Academy

Leave a reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>