excel on Win7

Copper Contributor

How can I arrange that data entered in a cell is automatically copied to a range of cells below?

3 Replies


Let's say the cell is E2.


Enter the formula =E2 in the cells where you want to copy the data,

Thanks, but not what is required.  I need a formula in place in a range of cells, such that when I enter data in the first cell, it is copied to all others in the range.  Then when I enter data in the next cell, IT is copied to the following cells.


I'm afraid I don't understand. Could you try to provide specific and detailed information about what you want to accomplish?