Stop manually inserting rows and columns—use Excel's "secret" right-click-drag menu to move, swap, and convert data instantly ...
When I was using Excel 2003, I could easily adjust which direction the cursor would move—either to the right or down—after I entered data in a cell. But Office 2007 doesn’t seem to give me a choice.