How to Insert Multiple Blank Columns in an Excel 2007 Worksheet

A fast way to 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. (Don't click in a cell, but on the column identifying letter.) By default, Excel inserts a column to the left of the column that has been selected.


This works quickly if you want to add one blank column. But if you want to insert 12 blank columns, this wastes a lot of time!

If you find yourself needing to insert multiple blank columns in your Excel 2007 spreadsheets, you MUST learn this neat tip!

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. 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 from the Quick Access 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

If this post has been helpful, please consider linking to our blog or sharing!