0

Suppose you have a workbook riddled with array formula.

In Excel 2007, if you select any cell (which is part of an array formula), then hit F2 to edit, you have to go ctrl+shift+enter to enter the formula (which already exists) as an array formula. When doing this, all the cells that are part of the array formula are selected (highlighted).

However, in Excel 2010, this behaviour is different. Repeat the exercise: edit an existing array formula and re-enter with ctrl+shift+enter. Now, only the cells that are in the same column as the edited cell are selected, and only from the top of the array down to the current cell.

An example: suppose cells A1:J10 contain a single array formula. Select cell D6. Press F2, then ctrl+shift+enter. In Excel 2007, the entire range A1:J10 becomes selected. In Excel 2010, only the range D1:D6 is selected.

Is there a way yo get the behaviour from 2007 in 2010? I find this very useful when working on spreadsheets someone else created.

2 Answers 2

2

In Office 2016 or later, simply use Ctrl+/.  (Do this before you press F2.)

1
1

To see the whole group of cells that are linked into a single array formula:

  1. Click a cell that contains an array formula that calculates multiple results.

  2. On the Home tab, in the Editing group, click the arrow next to Find & Select, and then click Go To Special.

  3. In the Go To Special dialog box, click Current array.

This is directly copied from Microsoft. See link: bit.ly/1xSz1Xc

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .