Automatically move a line

Question

How do I make a row automatically move down when I add information above it without right clicking and adding a line.  I want the bottom line to move down as I add information above it.

Answer 1

In one workbook, I did write code to do this, predicated on the row being selected. That was because when the new row was created I wanted to insert certain information in the row by default and increment a counter.

Answer 2

Being a bit lazy, when I need to do this, I simply select the row, right-click and Insert a row above.

Doing this, you need to be cognizant of any formulae to make sure that your new row is (or is not) included.

Answer 3

Yes, Excel is designed to work like the way you have described in your post i.e. you will need to insert a row to move the bottom row down. There is no option to change this behavior (In Word or Notepad, if you press Enter, you move one line down unlike Excel)

You must have heard about Macro. VBA code is that.

What is the business need for this functionality which you are seeking? May be I can find some solution for your problem.

Answer 4

So your saying that Excel is not able to do this? and you have to write it into the program?  What is a VBA code?

Answer 5

This can only be done through a VBA change event which will capture change event because of Enter key and will do the job.

Please let me know if you me to write a VBA code for this.