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.
- Simply select a column or row and chose the appropriate command from the Insert ,enu.
- In Excel 2007 click the Home tab and select an item from the Insert drop-down int he Cells group.
- 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:
Insert Column | CTRL + space, CTRL + Plus sign |
Delete Column | CTRL + Space, CTRL + – |
Insert Row | Shift + Spcae, CTRL + Plus sign |
Delete Row | Shift + Space, CTRL + – |
It’s all in knowing where to look isn’t it?