I am working on a spreadsheet for quite some time and suddenly it is giving me an error - "To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet" whenever I try to insert a row.
I tried all the possible solutions that I found online such as removing formatting, going to the end of the worksheet to clear the cells, amongst others, but none of them work so far.
Is there any other solution to this error?
TIA!
Bookmarks