how to copy and paste array formula excel?
If you need to create single array formulas for each cell, then you have to copy the formula, then select the destination cells and paste the formula. You can also copy, not fill, if you hold Ctrl + Shift while dragging the fill handler.