Excel keyboard shortcuts insert row
![excel keyboard shortcuts insert row excel keyboard shortcuts insert row](https://cdn.educba.com/academy/wp-content/uploads/2019/01/insert-the-row-example-3.2.png)
Hold down Ctrl to select the cell one row down, and Shift + Space to select the row.įollow the same procedure to select multiple rows that you want to insert a row on top. Select the cell you want to insert a row above. Press Ctrl + Shift + + (plus) to insert a row above. To insert multiple rows using the context menu. Inserting multiple rows using the Ribbon. Excel will insert the same number of rows you selected. Press Ctrl + Shift + plus sign (+) at the top of the keyboard.
![excel keyboard shortcuts insert row excel keyboard shortcuts insert row](https://cdn.educba.com/academy/wp-content/uploads/2019/01/insert-the-row-example-2.3-768x302.png)
Select multiple rows using one of the methods above. Select the cell you want to insert a row above. Inserting multiple rows using a keyboard shortcut.
#Excel keyboard shortcuts insert row how to#
This section explains how to insert a new row on top of a cell using shortcut key. Tip: You can also select Home > Paste > Paste Special. After you’ve copied the data, press Ctrl+Alt+V, or Alt+E+S to open the Paste Special dialog box. Without numeric keypad: Ctrl + Shift + + (plus)Ĭommand + shift + + (plus) Insert a row above a cell Keyboard shortcuts in the Paste Special dialog box in Excel 2013 In Excel 2013, you can paste a specific aspect of the copied data like its formatting or value using the Paste Special options. Let’s take this opportunity to learn some useful shortcuts to improve our work efficiency. I will also show you how to insert a blank line every other line, so please refer to that as well. I will introduce a shortcut key to insert a blank line above a cell in Excel. Written in Excel for Microsoft 365 version 2201.Method 2 Inserting Rows on Windows 1 Open an excel spreadsheet. If you have no rows selected and press Control + Shift + + then it will not work. Your new row should appear above the selected one. Insert row above shortcut - Excel Hack Insert row above shortcut Type the Control + Shift + + keys at the same time to insert a row.