Excel will then add a row above the selected row.
#Keyboard shortcut to insert comment in word plus
Simply click a row number to select a row, hold down the Ctrl and Shift keys, and press plus (+). Luckily, there is an easy keyboard shortcut for this: Ctrl+Shift+Plus.
Sometimes you may want to add a blank row to your spreadsheet. Which key is used to add row in the table? To select non-adjacent rows or columns, hold Ctrl and select the row or column numbers. Or click on any cell in the row and then press Shift + Space. Select the row number to select the entire row. How do you select a row using the keyboard? To add a row below the cell, click Insert Below in the Rows and Columns group. Under Table Tools, on the Layout tab, do one of the following: To add a row above the cell, click Insert Above in the Rows and Columns group.Click in a cell above or below where you want to add a row.Right-click the selection, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones. To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. Ctrl+- (minus character) is the keyboard shortcut to delete rows or columns. If you are using a laptop keyboard you can press Ctrl+Shift+= (equal sign). What is the shortcut key for insert row column?Ĭtrl++ (plus character) is the keyboard shortcut to insert rows or columns. To quickly insert multiple rows, select multiple rows and use the same shortcut. To quickly insert a row in Excel, select a row and use the shortcut CTRL SHIFT +.