Suppose, I want to reduce an array size (count of cells). Array had been created by Ctrl+Shift+Enter.
If I try to select part of array and press Ctrl+Shift+Enter, Excel prints an error message
"You cannot change part of an array."
It does not allow me to change the array size, because I had not selected the whole array.
So, I have to select all the array, remove it, select the reduced cell range and enter the formula again (I save the formula into clipboard before this).
Is there any method without the array removal?