Insert Columns and Rows Using the Keyboard

To insert a columm using the keyboard, you first have to highlight the column

Highlight a Column

To highlight a column in Excel, place the cursor anywhere in the column you want to highlight

Press Ctrl + Spacebar

This will highlight the column

Insert Column

Press Ctrl and + (repeat this step for multiple columns)

It will insert a column to the left of the highlighted column

To insert a row using the keyboard, you first have to highlight the row

Highlight a Row

To highlight a row in Excel, place the cursor anywhere in the row you want to highlight

Press Shift+ Spacebar

Insert Row

Press Ctrl and + (repeat this step for multiple rows)

It will enter a clear row above the row you have highlighted