Allow users to change default behavior when inserting rows while there is content in the clipboard
I usually copy some cells and then go somewhere else in a workbook to paste it but realize I need to create space first by adding rows or columns. When you insert a row with content on the clipboard it repeats whatever you had copied in every cell in the column. This is a huge operation and usually crashes excel.
I've never wanted to add a new row with the clipboard content repeated in every cell and excel can't even handle it so why is that default?
Kevin Trumbull commented
Luckily I've also been issued a MacBook Pro. Apple's Numbers application does not suffer from this flaw. (It's missing some features I like, but it's way more efficient for data entry and I never feel like I'm fighting with stupid UI decisions.).
Actually, I just checked LibreOffice, and it's also able to right click on a row and add rows REGARDLESS of what's in the clipboard.
Honestly, the biggest problem I have with Microsoft (software) and Apple (Hardware, and sometimes software) is that the two companies think they know what I want and how I work better than I do. Unfortunately for me, you're both often wrong. So if you'd stop hiding/removing the insert row/column option in the context menu when the clipboard's not empty it'd be one less thing getting in my way for getting stuff done.