Excel Quick Tip: Add a New Row with a Shortcut

preview_player
Показать описание

We hope you enjoy!
Рекомендации по теме
Комментарии
Автор

Doesn't work for the latest Excel. While attempting to make this work I accidentally found out that Alt + Enter adds a row above the selected row.
To insert multiple rows, select the corresponding number of rows below where you want to add these new rows and press Alt + Enter.

felixpham
Автор

You can also use shortcut key Alt+I+R, that would be much easy. No need to select the row.

robinsinghyadav
Автор

It's not working !!
I have ms excel 2007. I followed all the steps but nothing happened😒

symaperween
Автор

So its fine and always added on Upper Row when use shortcut but i want add Lower Row..is it possible?
And What about delete row shortcut?

pawankumarangadi