Forum home » Delegate support and help forum » Microsoft Excel Training and help » Array formulas

Array formulas

ResolvedVersion 2010

Mon 8 May 2017, 16:56 Delegate Matthew said...

Matthew has attended:
Excel Advanced - Formulas & Functions course

Array formulas

If I have a complicated array formula that I would like to extend, because the number of rows with data has increased, what is the best way of extending the array to include all of the rows. I cannot just drag down as the output from the array formula depends on all previous data?

Tue 9 May 2017, 13:27 Trainer Marius said...

RE: Array formulas

Hi Matthew,

Thank you for your question. One way to extend your array to include new records is to select the existing array formula cells plus the empty cells next to the new data. Then, press F2 to adjust the cell references in the formula to include the new records. Finally, press Ctrl+Shift+Enter to refresh the array.

I hope this helps.

Kind regards
Marius Barnard
Excel Trainer

Tue 16 May 2017: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips

Array formulas

Array formulas

RE: Array formulas

Excel articles

Excel tip:

Using Alt in Save Dialog Box