Creating new row pastes clipboard to infinity and crashes Excel.

[Andrzej Rutkowski]

When I want to add a new row or column, I click on the neighbouring one and use [ctrl] + [plus sign]. In Excel 2013, it just created a new row/column and maybe copies the format from the neighbouring ones. In Excel 2016, someone decided that when I want to create a new row/column, surely I want to paste whatever I have in the clipboard into every single cell of that new row/column. To infinity! And it crashes Excel and I lose all my recent changes. Does anyone know how to turn this brilliant feature off?

[#2]

Hi Andrzej,

Ctrl+Plus on numpad or Ctrl+Shift+Plus on main keyboard is the shortcut to insert new column, row, cells - depends on where you stay - and works in 2016 exactly the same way as in 2013. If not, most probably something is wrong with your installation.

https://support.office.com/en-us/article/keyboard-shortcuts-in-excel-for-windows-1798d9d5-842a-42b8-...