One difference that I have noticed in the two versions, is how the array formula entry behaves on already existing arrays (pressing ctrl-shift return).
In Excel 2003, after array formula entry, the current array gets selected.
In Excel 2010, after array formula entry, the current cell gets selected.
Please see illustrated example below:
Excel 2003
A basic array formula is entered
After array formula entry (ctrl-shift return), the current array is selected
Excel 2010
A basic array formula is entered
After array formula entry (ctrl-shift return), the current cell is selected
If we want to select the current array in Excel 2010, another method is necessary
Select goto special in the ribbon menu
and choose current array in the panel that shows
No comments:
Post a Comment