I learned Excel on a Mac with Office 97 or earlier versions and frequently used keyboard shortcuts such as command-i to open a new row, paste in a row already selected, and delete the old row (moving a row). I also liked to enter a formula by typing = and then clicking on a series of cells to add up the cells. None of those techniques seem to work in newer versions on either Mac or PC. On the formula entry it is now necessary to type a + sign between every click...very cumbersome in comparison to the old way.

Is there a way to revert to the old set of shortcuts and formula entries?? I've tried building Macros, but Excel loses the clipboard selection when I insert a row in the example above.