Question

What is the shortcut key to copy formula to all the cells ?​

Answer 1

Explanation:

When we are entering data or a formula in a cell, and have multiple cells selected, Ctrl+Enter will copy the data/formula to all of the selected cells

Answer 2

Answer:

Here's the key step: instead of hitting ENTER the way you normally do, hit CTRL + ENTER and Excel will replicate the formula in all of the selected cells.

Explanation:

:-)