Add Column (Excel Shortcut)

Adding a new column in Excel is a very easy task. Many times, while working with data, users want to add or insert a new column and they can do it using keyboard shortcuts instead of going to the “Insert” icon under the “Home” tab.

Keyboard Shortcut to Add Column in the Excel

AltIC

shortcut-keys-to-add-column

Ctrl + Shift + +

shortcut-keys-to-add-column

Steps to Add Column Using Keyboard Shortcut

Using keyboard shortcut Alt → I → C

  1. First, click on any cell to the left of which you want to add the new blank column.
    3-select-the-cell
  2. After that, simply press “Alt → I → C” and you will get the new column inserted to the left of the selected cell.
    4-new-column-added

Using keyboard shortcut Ctrl + Shift + Plus Sign (+)

  1. First, select the whole column using the keyboard shortcut “Ctrl + Spacebar” to the left of which you want to add the new blank column.
  2. After that, press shortcut keys “Ctrl + Shift + Plus Sign (+) and you will get the new blank column inserted to the left of your selected column.

Points to Remember

  1. Excel always adds the column(s) to the left of your selected cell or column, we cannot change this default setting.
  2. Once you added a column, you can just press the “Fn+F4” keys for Excel to repeat the task to add more blank rows.