![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |