Shortcut Key to Insert Columns in Excel!! 2 STEPS

Inserting a new column in Excel is super easy with a shortcut key and only takes two quick steps. Instead of using the mouse and searching through menus, you can simply select a column and use a keyboard shortcut to add a new column instantly. In this blog, you’ll learn the two-step shortcut method to insert columns in Excel, making your work faster and more efficient.

---

The 2-Step Shortcut to Insert a Column

Here are the two steps you need to follow:

1. Select the Column
   • First, select the entire column where you want the new column to appear next to.
   • Use Ctrl + Spacebar to select the whole column.
2. Insert the Column
   • With the column selected, press Ctrl + Shift + + (plus sign).
   • This opens the “Insert” dialog, and by default, it inserts an entire column to the left.

That’s it — two steps, and you’re done.

---

Conclusion

• Step 1: Ctrl + Spacebar → select the column
• Step 2: Ctrl + Shift + + → insert the column

Or, alternatively, use Alt + I + C if you prefer the menu-driven shortcut.

Using these two steps can drastically improve your efficiency in Excel, especially when you’re working on large datasets and need to manipulate structure quickly.