Forum Discussion
How do I edit an array on Excel without having to start over?
SergeiBaklan I checked. There is no drop function in the formula list.
DROP is currently only available in Excel in Microsoft 365 (and Excel Online), not in Office 2021 or older versions.
Try
=INDEX(array, 0, 1)
- Good attempt, but it still says I can't alter part of an array.
Are you using a CSE array formula to return the selected column? I used to enter all formulas with CSE and I was thankful to be able to move to dynamic arrays at the beginning of 2019.
If it is a CSE array formula you can enlarge it by selecting the new range and re-entering with CSE but you can't reduce the size.
For that you would need to copy paste the lead cell and then delete the CSE array in its entirety. From there you can use the copied single cell formula to rebuild a new array formula.
Better, just license 365 and move on.
- That's essentially what I ended up doing. I thought there might be a more efficient method, but I ended up spending way too much time trying to find it.
Oh, you're trying to delete part of the result of an array formula. As the error message says, you cannot do that. The replies by SergeiBaklan and me assumed that you wanted to return a single column to another range.
You'll either have to change the formula so that it returns only one column, or copy the result range and paste it as values. You can then delete two of the columns since there is no formula anymore.
