Shortcut key no longer doing what it should be - Microsoft Community

in previous versions of excel, hitting f4 repeated last action, pretty irrespective of is.  in excel 2016 no longer case.

the issue when inserting blank cells. not columns, or rows, odd cell(s).  in past, has never caused me frustration.  now, however, causes me huge frustration, because if have copied and pasted anything point of trying insert blank cells, whilst working in worksheet, hitting f4 doesn't repeat last action, inserts copied cells.

previously shortcut inserting cells was alt+i+e.  yes insert copied cells, once pasted programme forget them, , hitting shortcut again insert new cell(s), number of being dictated whether or not had highlighted cells. though, hitting alt +i+e insert blank cells if have not copied since opening document.

i try ctrl+ behaves differently in if insert new cells, , hit crtl+y, nothing, absolutely nothing.

this driving me bonkers - why excel abhorrently against inserting blank new cells?????!!!!!

new recently: copied cell retained. (copy , paste cell; observe ant-track stays in place)

to release use esc after paste

then f4 work before

best wishes

Office / Excel / Windows 10 / Office 365 for business