How Do I Add a Column in Excel 2007?

I was recently asked how to add a column in Excel version 2007. I don’t know too many folks who are thrilled with the Ribbon interface, but once they learn how to navigate it seems to grow on them.

Inserting a column or row into an Excel worksheet is easy.

1. Simply select a column or row and chose the appropriate command from the Insert ,enu.
2. In Excel 2007 click the Home tab and select an item from the Insert drop-down int he Cells group.
3. If you are like me, you will prefer the shortcut version which is right-click a selected column or row and select Insert from the resulting menu.

Excel will insert a column, pushing everything to the right by one column.

When inserting a new row, Excel will shift everything down by one row.

There are some other shortcuts you can use without using your mouse:

It’s all in knowing where to look isn’t it?