EXCEL: Insert Multiple Columns at Once

Suppose you have three columns (Column B, Column C, and Column D) that contains information, then you want to insert blank columns in between these columns here is how to do it:

• Hold down control key.
• Select one column at a time
• Right click and choose Insert
• Done!

Suppose now you want to insert three blank columns to the left of columns Column B,  here is how to do it:

• Select column B, C and D at a time
• Right click and choose Insert
• Done!