Editing or Deleting Arrays

Since a single formula is entered in all the cells of an array, you can t change or delete part of an array if you try, you ll get a Carmot change part of an array message. 

To edit an array formula, simply select any cell in the array. Then edit the formula in the formula bar. When you begin to edit, the braces surrounding the formula will disappear. To re-enter the edited formula, press CONTROL+SHIFT+ENTER. The formula will be entered into all of the cells originally selected for the array. 

Although you can t change part of an array s formulas or values, you can format individual cells. You can also Copy values from individual cells of an array and Paste them elsewhere. 

You can select individual values in an array by using the INDEX function, but this is a read-only option. If you need to be able to change individual values in an array, you should enter the values in a range of worksheet cells, rather than as an array. 

Excel Tip. To select an entire array range (in order, for example, to Clear it), 

---