Excel Hack

Insert column in Excel shortcut

Inserting an empty column in Excel is usually done by right-clicking. However, if you use the shortcut key, you can skip the right-click operation. It is also possible to insert multiple columns using shortcut keys. Learning how to use the Insert Column shortcut will make your work in Excel easier and more productive.

Insert column shortcut

Windows
With numeric keypad: Ctrl + + (plus)
Without numeric keypad: Ctrl + Shift + + (plus)
Access Key: Alt + I + C

Mac
command + shift + + (plus) or control + shift + + (plus)

Insert single column

Here is how to insert a single column using the shortcut key.

Total Time: 1 minute

Select a cell

Select a cell

Select the cell into which you want to insert a blank column.

Select an entire column

Select an entire column

Press Ctrl + Space to select the entire column.

Column insertion complete

Column insertion complete

Press Ctrl + Shift + + (plus) or Alt + I + C to insert a column.

Inserting a column from the Insert dialog box

Select a cell

Select the cell into which you want to insert a blank column. Press Ctrl + Shift + + (plus).

Select an entire column

The Insert dialog box will appear.

Use the (Down Arrow key) to select the Entire column, and press Enter.

Insert a column

A column has been inserted.

Insert column in context menu

Select a cell

Select the cell into which you want to insert a blank column.

Select an entire column

Press Ctrl + Space to select the entire column.

Select Insert

Press Shift + F10. Use (Down Arrow key) to select Insert.

Select a column

A column has been inserted.

Insert multiple columns

Select a cell

Select the cell into which you want to insert a blank column.

Select multiple cells

Press Shift + (Right Arrow key) to select multiple cells. Press Ctrl + Shift + + (plus).

Select an Entire column

The Insert dialog box will appear.

Use the (Down Arrow key) to select the Entire column, and press Enter.

Completed inserting multiple columns

Multiple cells have been inserted.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments