Using Enter Key to insert a blank row

[katimarie1991]

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.

[Tank997]

Try the table feature on the insert tab. you can insert rows in a table with the tab key and keep a total row below the data. I don't think it can be done with the enter key without VBA. Good Luck!

[Richard Buttrey]

Hi,

I'd be inclined to avoid the ubiquitous Enter Key else how else would you use the Enter key for the myriad of stuff where you don't want to add a blank row. I'd use the sheet before double click event macro instead. i.e.

Please Login or Register  to view this content.

Now whenever you double click a cell a blank row will be inserted below.

Again, and just as an aside, I'm always puzzled why users stick slavishly to the concept of having a total below a set of data. I know with traditional pencil and paper that's where totals always were, but it makes more sense with a spreadsheet, where often additional rows need to be added, to have the total row as a fixed row above any data. Then just ensure any total formula covers as many rows as you are ever likely to have, or better still apply dynamic range names to cell ranges and use the name in the total formula.