Forum Discussion
How do I edit an array on Excel without having to start over?
I have a 3X3 array and I'm trying to take away two columns which are simply copies of the first. How do I do it?
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.
