Excel 2007: Easily Insert Rows or Columns in Excel

With a Microsoft Office Excel document open, you can insert extra cells, rows or columns by holding down the SHIFT key while you grab a cell, row or column by its AutoFill handle and drag it in the direction you want the insertion made.