45. Excel Tips - Modify Array Formula

This is a follow-on from tip on entering an array formula in Excel
Once you have entered and array formula in Excel, you will notice that Excel won't let you modify it one cell at a time.
Suppose the matrix we have is now a 3 by 3 matrix, and we have the formula for a 2 by 2. How do we modify the array formula ?
- Step1: Select range F3 to H5
- Step2: Press F2
- Step3: Press- CTRL (and hold it down) SHIFT (and hold it down) ENTER
Download a spreadsheet to practice modifying array formulae
Training Video on how to Modify an Array Formula:
»
- Nick's blog
- Login or register to post comments
- 14555 reads
Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 47 weeks ago
6 years 50 weeks ago
6 years 51 weeks ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago