The problem is fundamental to the spreadsheet data model. Spreadsheets use the "big bag of cells" data model, where anything can go anywhere. The people who enjoy spreadsheets like this data model, it is very quick to get something up and running. Those of us who don't like spreadsheets hate it. it encourages the mixing of data and code. it promotes coding via copy/paste and all the opportunities for code/data addressing mismatches that go with it. But for me the thing that drives spreadsheets from mildly annoying to outright dislike is that there is very little done to keep data rows intact, it is very easy for items in a row of data to end up where they shouldn't be. All I really want is row security... So I ended up replacing my spreadsheets with relational databases. the UI sucks in comparison. but at least my rows stay intact.