Shortcut to Insert or delete Row or Column in Excel

In order to insert a row in Excel, press Alt, I and R. This will insert a row above the active cell.

Similarly, to insert a column, press Alt, I and then C. This will insert a column to the left of the active cell.

To delete a row or column , press Alt, H, D and the R (for Row) or (C for column). This will delete the row or column of the activecell. 
Share: