Solved Using Enter Key to insert a row in Excel 2007

April 1, 2013 at 07:12:50
Specs: Excel 2007
I appreciate all help, here is my situation, my boss would like to use the enter key to insert a row. The format is a list of all the students that are attending a class, there is a total number of personal listed at the bottom of the column, therefore he wants to just click on student 14 hit enter and have a blank row between student 14 and the final total. Any and all help will be greatly appreciated.

See More: Using Enter Key to insert a row in Excel 2007

Report •

April 1, 2013 at 08:02:18
✔ Best Answer
I don't believe that it can be done with the Enter key. Even if it could, I don't think that you would want to change the function of the Enter key.

Since he is already using the mouse to click on "student 14", all he needs to do is Right-Click the Row number of the Total row and choose Insert. He doesn't even need to select a cell first, he can right click directly on the Row number.

Another option is to use the keyboard once a cell is selected. If he presses Alt+i+r it will insert a Row above the selected cell and place the cursor in the same column of the new row. No mouse needed.

One more option is to right click any cell and choose Insert then the Entire Row radial button. That will do the same thing as using Alt+i+r.

Changing the function of the Enter key can be dangerous.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question