66.2k views
1 vote
Which excel feature makes it easy to copy and paste formulas in multiple cells?.

User Asare
by
4.7k points

1 Answer

14 votes

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.

Step-by-step explanation:

User Citronas
by
5.5k points