I am trying to setup a workbook that will contain many rows of data. In order to keep things chronological I would like to consistently (or always) insert a new row of data at the top of the spreadsheet, instead of having to scroll down to the last entry. I should end up with the most recent data on top.
The question is, can I do this without having to right click on the first row (in between the header row) and chose Insert Row or right click on the cell Choose Insert, Entire Row. I'm envisioning here a way to setup like a blank form row that I could enter my info for the entire row and hit a button (or look for an Enter key in the last column's cell) and this would insert that row information into that top row that I keep referencing. Is this possible? Am I dreaming here?