How to Copy an Array to a Range in Excel 2007

Save

Array formulas are a way for a computer to greatly improve performance in handling data and multiple calculations, and allow Excel to do some database-like functions. Arrays are powerful and very useful; one array formula can replace several thousand formulas in a complex spreadsheet. Copying an array to a range of cells in Excel is a straightforward process, though modifying an existing array is often more work than deleting it and creating a new one.

Things You'll Need

  • Excel 1995 or later
  • Open Excel and load the worksheet with the data sets you want to use to feed an array formula.

  • 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.

  • Select the cell with the newly entered array formula. Hit "Ctrl"-"C" to copy it.

  • Select the other cells in the range you want in the array formula. Hit "Ctrl"-"V" to copy the array formula throughout the range.

Tips & Warnings

  • You can also select the range of cells and enter the array formula in the formula bar. This may be faster (in both data entry time and performance) than manually cutting and pasting array formulas into each cell in the range.

References

  • Photo Credit BananaStock/BananaStock/Getty Images
Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!