When three cells are selected, whatever the data is in the first cell, it is copied to the other two cells.CTRL + D works when copied data is being passed down, not upwards.The only thing to remember in the CTRL + D shortcut key is that it works only in columns and not in rows.We have seen from our examples that even if the data is normal data or have formulas or have some sort of conditional formatting, CTRL + D works in every scenario. Now, as we have learned above, CTRL D is another shortcut in excel which does copy and paste the data. We can see that apart from formulas, even formatting does copy and paste using the shortcut key. In the above data, we have cell G1 conditionally formatted, and formatting is such that any value above 350 and below 450 will have the same cell color as cell G1, which is orange. Now let’s use the same data and use conditional formatting in cell G1 and then we will copy formulas using CTRL + D shortcut key and see if the formatting gets copied or not. It can copy and paste formulas too in excel.

Now check whether the formulas can be pasted using this shortcut key or not, and click on any cell in the G column.Select Cell Range B2:F2 and press the Enter key.In cell G1, we will write a sum formula and use CTRL + D to copy-paste the formulas. Now let us try to use CTRL + D in cells containing formulas to check whether CTRL D works only in the normal data or works in formulas. We have seen above how the shortcut key or Ctrl + D works in excel. Now insert data for Lee as per the requirements,.Now, Select the cells we want the same data to be in, i.e.For Robin, insert the data for amount and class.

What does ctrl v