Ctrl + D The Secret Revealed

Ctrl + D The Secret Revealed
Last Updated on 25/02/2021
Reading time: 3 minutes

Excel has more than 500 shortcuts (source: the developers) and some of them are amazing like Ctrl + D with the graphic objects 😎

Standard use of Ctrl + D

The shortcut Ctrl + D copy Down the contain of your active cell (value or formula).

Basic Ctrl D action

But for this, the easiest way it to use the fill-handle. So in this situation Ctrl + D is really not helpful 😕

How to copy formulas with the mouse

Use Ctrl + D with graphic objects

But, if you work with graphic objects like charts, shapes or icons, this shortcut is really great 😍

Import an icon

For exemple, let's import the symbol man from the menu Insert > Icon

Menu Icon

Then, in the next dialog box, you search for "man" and you select the following icon

Select the Man icon

Crop the icon

Once the icon has been added to your worksheet, you can see that there is extra blank to remove around the icon.

We must remove parts of the icon

To do that, we must cropped the icon with the option Graphics Format > Crop

Menu Crop picture

Now here is the steps to remove the blank part around the picture

  1. Click on the Crop icon
  2. Remove the blank part
  3. Click again on the Crop icon to keep your changes
Crop Image with Excel

Duplicate the icon

Now, let's see how to duplicate this icon to create a series of icons like we did for our custom people charts.

Cover Progress bar with icons

This is where the shortcut Ctrl + D will be very useful

  1. Select your picture
  2. Press Ctrl + D

This action will duplicate your pictures, icon, chart. But the result isn't acceptable 😵🥴

Ctrl D duplicates the picture

Adjust the position of your icon

Of course, the position proposed by the duplicate action isn't the one we want. So, let's move the picture to the correct location.

Move the icon next to the previous one

NOW, here is the secret of Ctrl + D

  1. We have used Ctrl + D to duplicate the picture.
  2. Then we have moved the duplicate icon to the position we want.
  3. AND NOW, the next Ctrl + D ...... will duplicate the icon AND KEEP the previous move 😮👍
Secret behind Ctrl D

With this shortcut, you save a lot of time with the position of your graphic object 👍😍

Leave a Reply

Your email address will not be published. Required fields are marked *

Ctrl + D The Secret Revealed

Reading time: 3 minutes
Last Updated on 25/02/2021

Excel has more than 500 shortcuts (source: the developers) and some of them are amazing like Ctrl + D with the graphic objects 😎

Standard use of Ctrl + D

The shortcut Ctrl + D copy Down the contain of your active cell (value or formula).

Basic Ctrl D action

But for this, the easiest way it to use the fill-handle. So in this situation Ctrl + D is really not helpful 😕

How to copy formulas with the mouse

Use Ctrl + D with graphic objects

But, if you work with graphic objects like charts, shapes or icons, this shortcut is really great 😍

Import an icon

For exemple, let's import the symbol man from the menu Insert > Icon

Menu Icon

Then, in the next dialog box, you search for "man" and you select the following icon

Select the Man icon

Crop the icon

Once the icon has been added to your worksheet, you can see that there is extra blank to remove around the icon.

We must remove parts of the icon

To do that, we must cropped the icon with the option Graphics Format > Crop

Menu Crop picture

Now here is the steps to remove the blank part around the picture

  1. Click on the Crop icon
  2. Remove the blank part
  3. Click again on the Crop icon to keep your changes
Crop Image with Excel

Duplicate the icon

Now, let's see how to duplicate this icon to create a series of icons like we did for our custom people charts.

Cover Progress bar with icons

This is where the shortcut Ctrl + D will be very useful

  1. Select your picture
  2. Press Ctrl + D

This action will duplicate your pictures, icon, chart. But the result isn't acceptable 😵🥴

Ctrl D duplicates the picture

Adjust the position of your icon

Of course, the position proposed by the duplicate action isn't the one we want. So, let's move the picture to the correct location.

Move the icon next to the previous one

NOW, here is the secret of Ctrl + D

  1. We have used Ctrl + D to duplicate the picture.
  2. Then we have moved the duplicate icon to the position we want.
  3. AND NOW, the next Ctrl + D ...... will duplicate the icon AND KEEP the previous move 😮👍
Secret behind Ctrl D

With this shortcut, you save a lot of time with the position of your graphic object 👍😍

Leave a Reply

Your email address will not be published. Required fields are marked *