moving column down when making new entry

[gmann101]

Hi

I am making a to-do list and I want to, when adding a new task, have the column move one cell down and put the task on top of column. That means I want the new tasks to be on top so i dont have to scroll down all the previous tasks to add a new one. Is that possible?

I know it is a bit confusing so here is an example.

(A2) is the typing cell and Task C is the new task

	A
1	Tasks
2	Do C
3	Do B
4	Do A
5

<tbody>
</tbody>

After typing in Task C i want it to move down on where Task B is (A3) and task B moving to task A spot (A4) and etc. And leaving the typing cell (A2) blank for a new entry.
So it would look like this:

	A
1	Tasks
2
3	Do C
4	Do B
5	Do A

<tbody>
</tbody>

Kind regards, Gmann

 

[ranman256]

Thats not how excel works.