Ctrl + D in Excel: Functions and How to Use - Compute Expert

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!

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more







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!

Learn Excel Dashboard Course


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


Excel Calculation

Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division in Excel

Average in Excel



Excel Formula

VLOOKUP Function in Excel

IF Function in Excel

SUM Function in Excel

COUNTIFS Function in Excel

SUMIFS Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text in Excel

Excel Worksheet Definition

Excel Range Definition

Excel Shortcuts



Excel Products & Services Recommendation

Best Laptops for Excel

Best Tablets for Excel

Best Keyboards for Excel

Best Mouse for Excel

Best Monitors for Excel



Excel Consultation

About Us

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2022 Compute Expert