Inserting a new row or column in a worksheet is a snap for experienced Excel users. However, it likely isn’t for those who are new to the application.
To add a new row or column, select the existing row or column that you want the new one to appear before. From the Insert menu, choose the Columns option or the Rows option, depending on what you want to insert. Excel will add the new column or row into your worksheet.
If you like prefer using the keyboard, you can add new columns and rows using keystrokes. Select the appropriate column or row, as you did in the previous steps, and pres CTRL++ (the CTRL key and the plus sign at the same time).