Insert Row (CRTL +) without pasting clipboard

[Kluski]

I have office 365 and we just had an update.

Before the update, I could copy/paste something (ctrl c/v). Then I could select a row and press "crtl +" to insert a new row. The new row would be clean, no pasting of current clipboard.

After the update, I press ctrl + and the entire row is filled with the clipboard. Now I have to either delete the contents of the row or delete the contents of the clipboard before I use crtl +.

Since I am trying to be efficient in my work, how do I insert a row with ctrl + and not paste the contents of the clipboard without having to go to the clipboard and clearing the clipboard out. Adding extra steps is defeating the purpose of having shortcuts.

 

[Yongle]

Try
{ALT} I followed by {ALT} R

 

[Kluski]

Thanks, I tried that and...

{Alt} I - gave me a note at the top of the screen: "Continue Typing the menu key from an earlier version of office or press esc to cancel." I tried pressing ctrl+ after, but nothing happened.

{Alt} R - just popped up the review tab

 

[Yongle]

Ah - you may get that if you use UPPER CASE

It wants lower case letters

 

[Yongle]

You could try

{ALT) I and keeping the {ALT} key depressed then clicking on R

 

[Kluski]

You could try

{ALT) I and keeping the {ALT} key depressed then clicking on R

Well, that worked. Thanks for the help. I guess that means Insert Row.

However, I would have liked if they left ctrl + alone and made Alt I R to be insert row filled with the clipboard selection. This is why people don't like change, lol. They change the things you typically use instead of adding a new feature. Adding is ok, changing is not as nice.

 

[Yongle]

There is no way that the the {CTRL} + change was intended because it puts values that nobody could possibly want into a row
- why would anyone want the same values to repeat all the way from left to right across the whole sheet?
At least we still have a workaround