Insert a New Row or Column - Excel Keyboard Shortcut

Hello all below is the method to insert a new row or column

For Inserting Rows 

1. Shift+SpaceBar = Select the current row
2. Ctrl+Shift+PlusSign = Insert row(s)

For Inserting Column

1. Ctrl+SpaceBar = Select the current row
2. Ctrl+Shift+PlusSign = Insert colum(s)

Hope this help others

auto increment option not working in excel 2007

Unable to drag cell corner to auto increment in excel 2007

To enabled the auto increment feature in the excel sheet, enable the check mark in the

Excel Options -> Advanced

Enable fill handle and cell drag-and-drop