![how to insert column excel shortcut how to insert column excel shortcut](https://www.excel-easy.com/examples/images/insert-row/insert-cells-dialog-box.png)
The shortcut key for inserting the row is CTRL +SHIFT + ” +” (plus sign), and the same shortcuts can be used for inserting COLUMN for the same. In Microsoft Excel, we have several shortcut keys for all functions where we have the shortcut key for deleting the row and column. Now do the same step to the other row to get the multiple rows, as shown in the below screenshot.A new row will be inserted after clicking on the Insert Sheet rows, as shown in the below screenshot.Now click on the Insert and click on the second option, “Insert Sheet Row”.First, select the highlighted where we are going to insert the new one, as shown below.
![how to insert column excel shortcut how to insert column excel shortcut](https://i.ytimg.com/vi/OEpnene0SmE/maxresdefault.jpg)
Here in this example, we are going to insert multiple rows by following the below steps. Assume that we have missed some sales data that we need to include rows at the selected one. Consider the sales data, which has Product Title, Brand, and MRP, etc.
How to insert column excel shortcut how to#
In this example, we are going to see how to insert multiple rows by following the below steps. We can now see the difference that a new white row has been inserted after the SKU row “97011” Now if we need to add any missing Sales data, we can easily enter the data. After clicking on the insert option, a new row will be inserted above the fourth row, which is shown in the below screenshot.Go to the HOME menu and select Insert and click on the Insert Sheet Rows option as shown below.
![how to insert column excel shortcut how to insert column excel shortcut](https://www.exceltip.com/wp-content/uploads/2019/08/14.gif)
First, select the row where exactly we need a new row here, in this example, we have selected the Third row where we need to insert a new row as shown below, which means Excel will insert the new row after the second row.So in these cases, we can insert the new cells or row in the worksheet, which is shown in the below steps as follows. Sometimes it is required to add additional rows and columns to add extra information in the data.
How to insert column excel shortcut download#
You can download this Insert Row Shortcut Excel Template here – Insert Row Shortcut Excel Template Example #1 – Insert CellsĬonsider the below example, which has sales data.
![how to insert column excel shortcut how to insert column excel shortcut](https://cdn.educba.com/academy/wp-content/uploads/2019/02/Shortcut-to-Delete-Row-in-Excel.png)
Insert Column Using right-click menu without Shortcut