Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

Yes sir. You can indeed. All you need to do is to record a macro in excel that will do this job for you and paste the data to the first row.

Copy the data you want to paste and start a macro. you can assign a macro to the custom button on the ribbon. this way it will only be single left mouse button click.

Macro should look similiar to this:

Rows("1:1").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Range("A1").Select
ActiveSheet.Paste

You will find a tips on how to use buttons in excel here: click And here is a guide to add it to the quick access toolbar : click

share|improve this answer
    
beautiful. thanks. got it to insert and remove the old data. –  ikathegreat Aug 17 '12 at 22:37
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.