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.