Ctrl + D in Excel: Functions and How to Use


Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> Ctrl + D in Excel: Functions and How to Use



In this tutorial, you will learn completely about the Ctrl + D (Command + D in Mac) shortcut in excel. We will discuss the shortcut functions and how to optimally utilize them when working in excel.

We have many button shortcuts we can use in excel and one of them is Ctrl + D. By mastering the Ctrl + D shortcut, you should be able to do your job in excel more productively.

Want to know what can Ctrl + D do for you and master the shortcut usage? Read this tutorial until its last part!







Function 1: Copy Above (Cell)/Top (Cell Range) Cell Content

Ctrl + D in Excel: Functions and How to Use - Screenshot of The Example for the First Ctrl + D Function

One of the useful Ctrl + D functions in excel is copying the content in the cell above the cell you highlight. If you highlight a cell range, then Ctrl + D will copy its top cell content to other cells in the range!

Using Ctrl + D, you can copy either data or formula. If you copy a formula, then its cell references will move accordingly to where you copy the formula (unless you use the $ symbols).

To better understand how to use this Ctrl + D function, here is the step-by-step to do it.

  1. Highlight the cell/cell range where you want to do the copy process. If you highlight a cell, highlight one cell below the cell which content you want to copy. If you highlight a cell range, make the cell which content you want to copy as the top cell

    Ctrl + D in Excel: Functions and How to Use - Screenshot of Step 1-1

  2. Press the Ctrl (Command in Mac) and the D letter buttons on your keyboard simultaneously
  3. Done! If you highlighted a cell, then the cell content will become the same as the cell above it. If you highlighted a cell range, then all its cell contents will be the same as the top cell

    Ctrl + D in Excel: Functions and How to Use - Screenshot of Step 1-3




Function 2: Duplicate an Object and Its Relative Position

Ctrl + D in Excel: Functions and How to Use - Screenshot of The Example for the Second Ctrl + D Function

Besides duplicating a cell content, you can also use Ctrl + D to duplicate an object in excel. Moreover, Ctrl + D won’t just duplicate your object normally. If you have duplicated the object before, then Ctrl + D will also consider the duplication position to the object when duplicating.

This can be useful when you want to duplicate an object multiple times with the same distance between the duplications. By using this Ctrl + D function, you don’t have to position your duplicate each time you finish your duplication process!



To better understand this Ctrl + D function, here are the chronological steps to utilize it.

  1. Select the object you want to duplicate

    Ctrl + D in Excel: Functions and How to Use - Screenshot of Step 2-1

  2. Press the Ctrl (Command in Mac) and the D letter buttons on your keyboard simultaneously. Doing that will make excel immediately duplicate your object

    Ctrl + D in Excel: Functions and How to Use - Screenshot of Step 2-2

  3. Drag the duplicate to the position where you want it next to the original object

    Ctrl + D in Excel: Functions and How to Use - Screenshot of Step 2-3

  4. If you need more duplication, then press Ctrl + D again while still selecting the duplicate
  5. Your new duplicate will mirror the position between your previous duplicate and your original object!

    Ctrl + D in Excel: Functions and How to Use - Screenshot of Step 2-5

  6. Repeat step 4 if you still need more duplicates

    Ctrl + D in Excel: Functions and How to Use - Screenshot of Step 2-6




Exercise

After you have learned the functions of and how to use the Ctrl + D shortcut in excel, let’s do an exercise. This is so you can understand what you just learned more practically!

Download the exercise file below and do the instructions. Download the answer key file if you have finished the exercise and want to check your answers! Or probably if you are confused about what to do!

Link to the exercise file:
Download here

Instructions:

Do the instructions in the appropriate sheet using the Ctrl + D functions!

Sheet 1
  1. Fill all the cells in the “Class” column with A-1!
  2. Copy the formula in the first row of the “Pass/Fail?” column to all of the rows!


Sheet 2
Duplicate the object in the sheet to the right, bottom, and diagonally, five times each. Make sure all the duplications have the same distance to each other!

Link to the answer key file:
Download here



Additional Note

You can also do the cell content copy function of Ctrl + D with the excel AutoFill feature.



Related tutorials for you to learn:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on




Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert