How to Copy an Array to a Range in Excel 2007

1. Open Excel and load the worksheet with the data sets you want to use to feed an array formula.
2. Select a cell and enter the array formula. For example, if you wanted to have the formula multiply the number in B1 by the number in C1, you'd enter the formula =B1*C1. Hit 'Ctrl'-'Shift'-'Enter' to make sure it's entered as an array formula.
3. Select the cell with the newly entered array formula. Hit 'Ctrl'-'C' to copy it.
4. Select the other cells in the range you want in the array formula. Hit 'Ctrl'-'V' to copy the array formula throughout the range.