Select Page

Excel Video 347 offers several tips to manage your array formulas. It’s easy to delete or move an entire array formula, but you can’t delete or move part of an array formula. It’s all or nothing. You can expand an array formula to include more cells, but you can’t contract an array formula to include fewer cells. Be sure to select the range of cells you want to expand to before editing the array formula. As always with arrays, remember to press ctrl+shift+enter to save the formula as an array.
The next trick will be to add constants instead of cell references to array formulas. Stay tuned. We’ll do that next.