#Copy formatting shortcut excel how to#

Here we discuss how to use CTRL D in Excel along with examples and a downloadable excel template. This has been a guide to CTRL D in Excel. 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.Press the Alt key to display the ribbon shortcuts, called Key Tips, as letters in small images next to the tabs and options as shown in the image below. For example, on the Home tab, the Number group includes the Number Format option.

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. The ribbon groups related options on tabs. 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.

Copy formatting shortcut excel