![Microsoft excel shortcut keys delete row](https://knopkazmeya.com/19.jpg)
![microsoft excel shortcut keys delete row microsoft excel shortcut keys delete row](https://3.bp.blogspot.com/-8y7OuGpfYMU/VD5A36usLII/AAAAAAAAE-4/MDJl1cVmwec/s1600/001.png)
![microsoft excel shortcut keys delete row microsoft excel shortcut keys delete row](https://cdn.educba.com/academy/wp-content/uploads/2019/02/Delete-Row-Shortcut-Example-3-300x180.png)
Three new rows are added above the selected rows.Press and hold the Ctrl and Shift keys.Press the Up arrow key twice to select two additional rows.Select a cell in the row where you want the new rows added.If you want three new rows, select three existing rows. If you want to insert two new rows, select two existing rows where you want the new ones to be located. Tell Excel how many new adjacent rows you want to add to the worksheet by selecting the same number of existing rows. To Add Multiple Adjacent Rows Using a Keyboard Shortcut
![microsoft excel shortcut keys delete row microsoft excel shortcut keys delete row](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/chrome_Vuy1WfIdk0.png)
![microsoft excel shortcut keys delete row microsoft excel shortcut keys delete row](https://1.bp.blogspot.com/-Ir6x0IUVQyY/UUHs1qlS2EI/AAAAAAAABY8/dPio70K6Wlo/s1600/6.png)
A new row is added above the selected row.Press the " + " key without releasing the Ctrl and Shift keys.Press and hold the Ctrl and Shift keys on the keyboard.Press the Spacebar without releasing the Shift key.Press and hold the Shift key on the keyboard.Select a cell in the row where you want the new row added.To Add a Single Row Using a Keyboard Shortcut This can also be done using a keyboard shortcut:Įxcel inserts the new row above the row selected. The key combination is: Ctrl + "+" (plus sign)īefore adding a row, tell Excel where you want the new one to be inserted by selecting its neighbor. If you have a keyboard with a Number Pad to the right of the regular keyboard, use the + sign there without the Shift key.
![Microsoft excel shortcut keys delete row](https://knopkazmeya.com/19.jpg)