# Thursday, February 10, 2005

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!

Thursday, February 10, 2005 8:59:48 AM (Pacific Standard Time, UTC-08:00)  #    Comments [0]