Normally when we need to insert a row or column in Excel, we run a few steps to do it like right click->Insert…->Shift Cell down….and etc.

Here i going to show you how to add and delete row or column by using shortcut key on Mac:Excel.

A) To insert Rows

• Press SHIFT + Spacebar to select the rows
• After that, press CTRL + i to insert the row

B) To insert Columns

• Press CTRL + Spacebar to select the column
• After that, press CTRL + i to insert the row

C) To delete Rows

• Press SHIFT + Spacebar to select the rows
• After that, press CTRL + K to delete the row

D) To delete Columns

• Press CTRL + Spacebar to select the columns
• After that, press CTRL + K to delete the column

Hope this tricks will help u…:-)