How to Insert Multiple Blank Columns in an Excel 2007 Worksheet

The usual way to quickly insert a blank column in Microsoft Excel is to click on the column to the right of where you want the blank columns inserted, right-click, and click Insert.

You do not click in a cell, but you select or highlight the whole column by clicking on the column letter or identifier.

By default, Excel inserts a column to the left of the worksheet column that has been selected.

This works great if you want to add one blank column. But what if you need to insert multiple blank columns? Is there a better way? Yes!
If you need to insert multiple blank columns in your Excel worksheets, you MUST learn this neat method!

1. In your Excel document, click the little arrow after the Quick Access Toolbar in the upper right corner.
2. Click More Commands down near the bottom of the dropdown list.
3. Click Insert Sheet Columns from the list and click Add. Then click OK.
4. You just added a new icon to the Quick Access toolbar as shown in the image below.

5. NOW ... to insert multiple blank columns, highlight the column to the right of where you want the blank columns inserted and click the Insert Sheet Columns icon you just added to the toolbar. AND JUST KEEP CLICKING the icon in the Toolbar until you've inserted the number of blank columns you require!

Cool, huh.

►  Take a look at some of our other interesting posts, such as How to Display Formulas in an Excel Spreadsheet