'Can't Change part of an Array' - Microsoft Excel

Possibly, one of the most annoying errors i encounter in Excel. Why can't I change a part of an array? In this video, I show you how to resolve this issue

#Array #CtrlShiftEnter #CantChangePartOfanArray

[premawilson]

My dear...I love you so much, My dear...I love you so much, for the last 3 months I have been struggling with my excel with the above problem, I watched some youtuber but I could not get any solution from anyone because the way they demonstrated it I can hardly understand. In fact it was very easy after watching your video. 3 months problem solved. Thank you again.

[wayneedmondson]

Hi Victor. Great tip! Note that you can also use the keyboard shortcut CTRL+/ to select the current array. Saves time vs. using the Go To Special dialog. Thanks for sharing your tips! Thumbs up!!

[WorldCitizenJeff]

Thank you! WAY better, clearer, simpler explanation than other folks... including Microsoft! Happy to subscribe!

[AlexOrth-fhon]

I was working on a project for school and this solved my problem where I was unable to sort my values. Thank you very much!

[newprojeyar]

Thank you for your very good and excellent video. I was stuck with this error for several hours, which was solved by your good explanation. Wishing you health and success

[hasanahrahman]

Great tips! Thank you so much. Very clear explanations and easy steps to follow. 👍🏻

[prasadkargutkar]

Thank you, great solution also the explanation behind it made me understand the concept also

[afamrammopo]

Oga I heard your voice and subscribed immediately. Well done and thanks.

[mohammadhajibeigy]

Thanks a lot, it was very clear and helpful. It saves me time and a headache. Excellent job and thanks for repeating it with a great example.

[nonoobott]

Nice. I honestly didn't know this and I've encountered this several times. Thanks for the easy explanation and even easier solution 👌

[intanfajribestari]

Thank you! the explanation is so simple an clear

[amjadhunza]

This error drove me crazy and than you for making it so simple.

[Supr]

Hmm, in excel for me "find and select" is a much smaller menu and there is no "go to special". When I press ctrl+G I also get a "go to" window with no "special" button and again with a different appearance. Seems like Microsoft removed the feature - very annoying.

[hariishr]

Very useful,
Recently I was trying to add a column then I was getting this error,
Will try your solution.
Thank you

[jjobanputtra]

Thank you the video. However I have one query if I put the array formula in one cell and the same formula I have to copy to the next 100 cells then I will just copy the array formula and paste it in other 100 cells.... but after doing ctrl+shft +enter for all 100 cells is very difficult task.... what is the alternate or shortcut to do this

[aisienpetereloghosa]

Thanks so much.. You really made my day

[kabuteymarcus]

Please after deleting the array cells how do i get the numbers that i had already enter?

[sutup]

when I click current array it tells me i have no cells when all my colums and rows are filled

[jonathansantioquia]

problem solved on the spot thanks brother

[kapillibossa]

when i do what u do it tells me cant find cells.Can u help me?