Excel Shortcuts to Insert or Delete Rows and Columns

Insert Row

This Excel Shortcut inserts a row or rows into a worksheet.

Insert Row
PC Shorcut:Ctrl++
Mac Shorcut:^+I
Remember This Shortcut:
+ for add

Insert Column

This Excel Shortcut inserts a column or columns into a worksheet.

Insert Column
PC Shorcut:Ctrl++
Mac Shorcut:^+I
Remember This Shortcut:
+ for add

Delete Row

This Excel Shortcut deletes a row or rows from a worksheet.

Delete Row
PC Shorcut:Ctrl+–
Mac Shorcut:^+–
Remember This Shortcut:
– for delete

Delete Column

This Excel Shortcut deletes a column or columns from a worksheet.

Delete Column
PC Shorcut:Ctrl+–
Mac Shorcut:^+–
Remember This Shortcut:
– for delete