Add columns with shortcuts
You can do all the steps you have done above easier and faster with keyboard shortcuts. All you have to do is to press certain key combinations on your keyboard to perform tasks and functions in Excel. Here’s how.
First, select the column letter. In our workbook, select column letter E.
Then hold down the keys “Ctrl” + “Shift” + “+“.
You get an instant column😀
Insert Column Hot Key
You can also use the Insert Column Hot Key. A hot key is a key combination to perform an action quickly.
The hotkey combination for adding a column is holding down “Alt” + “I” + “C“.
To use it, simply select a cell from a column you like to insert a column before it.
“Alt” + “I” is the hotkey for “Insert”.
“Alt” + “I” + “C” is the hotkey for “Insert columns”.
Insert a column using the right-click or standard menu option. Insert a column like a PRO when you use the keyboard shortcuts, especially the Insert column hot keys😎
This works not only in inserting one column but also inserting multiple columns in Excel!