A fellow that I'm working with asked how to insert a row or column into excel from the keyboard. I hate having to reach for my mouse unnecessarily while working in a keyboard intensive application and was sure there was a way. It's sort of a two parter:
One of the keyboard shortcuts I've seen previously in Excel but never committed to memory is the ability to select a row or column: <ctrl><space> for columns and <shift><space> for rows. You may use <shift><arrow key> to select, for example, cells from several rows and then hit <shift><space> to select those entire rows.
Now, choose <ctrl>+ to insert or <ctrl>- to delete. Viola! This also works with cut and paste operations: select a row or column, <ctrl>x to cut; move and select another row or column and hit <ctrl>+ to insert the cut data.
Good number crunching to you!