Inserting columns and rows in an Excel worksheet is an easy process. You can do this by simply selecting a column or row and clicking on Insert and the appropriate command.
- In Word2007 and 2010 you can click the Home tab and in the Cells group, use the drop-down arrow next to Insert to select an item.
But who doesn’t want to save time and keystrokes? There are a couple of other methods to accomplish the same thing without using the menu and ribbon.
Follow the steps below to learn how:
- Right-click a selected column or row and select Insert from the resulting shortcut menu.
- MS 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.
Now suppose you work in a very large firm and someone in the IT Department has disabled the shortcut menus.
There is still a way around it to save time. Use the Fill handle! I know, it can be a little tricky but you will quickly get the hang of it.
- First you select a column or row.
- Then depress your Shift key and drag the Fill handle one column to the right or left.
- If you want to insert a row, simply drag the Fill handle up or down.
When Excel displays a gray border around the adjacent column or row, just release the keys and a column or row will be inserted for you.
Unlike the other methods above, this method allows you to insert a column to the left or a row above the selection.