Discover new information and insights with the help of IDNLearn.com. Ask your questions and receive accurate, in-depth answers from our knowledgeable community members.
Answer:
Ctrl + R - Copy a formula from the cell to the left and adjusts the cell references. For example, if you have a formula in cell A2 and you want to copy it to cell B2, select B2 and press Ctrl + R. Tip. Both of the above shortcuts can be used to copy formulas to multiple cells too.
Explanation: