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
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.
0 kommentar(er)
