You can also select cells in a row or column by selecting the first cell and then pressing CTRL+SHIFT+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns). Note If the row or column contains data, CTRL+SHIFT+ARROW key selects the row or column to the last used cell.
https://support.office.com/en-us/article/insert-or-delete-cells-rows-and-columns-6f40e6e4-85af-45e0-b39d-65dd504a3246
1 In any version of Excel, you can also insert rows and columns by way of the worksheet frame. 2  As shown in Figure 2, select one or more rows or columns, right-click on the selection, then choose Insert.
http://www.accountingweb.com/technology/excel/quick-tips-for-inserting-excel-rows-and-columns
Similarly, you can insert rows above a selected row and columns to the left of a selected column. You can also delete cells, rows, and columns. Note Microsoft Office Excel 2007 has more rows and columns than ever before, with the following new limits: 16,384 (A to XFD) columns wide by 1,048,576 rows tall.
https://support.office.com/en-us/article/insert-or-delete-cells-rows-and-columns-6f40e6e4-85af-45e0-b39d-65dd504a3246
CTRL+/. Select the array containing the active cell. CTRL+SHIFT+O. Select all cells that contain comments. CTRL+\. In a selected row, select the cells that don’t match the formula or static value in the active cell. CTRL+SHIFT+|. In a selected column, select the cells that don’t match the formula or static value in the active cell. CTRL+[. Select all cells directly referenced by formulas in the selection.
http://www.asap-utilities.com/excel-tips-shortcuts.php
1 Excel 2003 and earlier: Choose Insert and then Sheet Rows or Sheet Columns. 2  In any version of Excel, you can also insert rows and columns by way of the worksheet frame. 3  As shown in Figure 2, select one or more rows or columns, right-click on the selection, then choose Insert.
http://www.accountingweb.com/technology/excel/quick-tips-for-inserting-excel-rows-and-columns
Insert rows on a worksheet. Do one of the following: To insert a single row, select either the whole row or a cell in the row above which you want to insert the new row. For example, to insert a new row above row 5, click a cell in row 5. To insert multiple rows, select the rows above which you want to insert rows.
https://support.office.com/en-us/article/insert-or-delete-cells-rows-and-columns-6f40e6e4-85af-45e0-b39d-65dd504a3246
To delete selected columns, click the arrow next to Delete, and then click Delete Sheet Columns. Tip You can right-click a selection of cells, click Delete, and then click the option that you want. You can also right-click a selection of rows or columns and then click Delete.
https://support.office.com/en-us/article/insert-or-delete-cells-rows-and-columns-6f40e6e4-85af-45e0-b39d-65dd504a3246
Inserting new rows and columns is an easy task. Simply select a row or column and choose Row or Column, respectively, from the Insert menu. Excel will insert a new row above the selected row and a new column to the left of the selected column. Like most Excel tasks, you don't need your mouse at all. If you prefer, you can get the same results from the keyboard. Simply select a row or column and press [Ctrl]+[Shift]+=.
http://www.techrepublic.com/blog/microsoft-office/quickly-insert-rows-and-columns-into-an-excel-sheet/
1 Press Alt-4 once to insert the initial row, and then press either F4 or Ctrl-Y to repeat this action. 2  Hold down the Shift key and then use the Down arrow key to select multiple cells. 3  Press Alt-4 to insert multiple rows at once.
http://www.accountingweb.com/technology/excel/quick-tips-for-inserting-excel-rows-and-columns
1 Press Alt-4 as many times as needed. 2  Press Alt-4 once to insert the initial row, and then press either F4 or Ctrl-Y to repeat this action. 3  Hold down the Shift key and then use the Down arrow key to select multiple cells. 4  Press Alt-4 to insert multiple rows at once.
http://www.accountingweb.com/technology/excel/quick-tips-for-inserting-excel-rows-and-columns
what is the short keys to insert a row in excel?
One can insert a row in Excel by pressing ALT and 4 and then repeat this action by pressing either F4 or Ctrl and Y keys.