Automatic extend formula in column

[DarrenF]

Is there a way when I paste new information in column A, I can get column B to auto populate down the column for new rows I added when pasting information in Column A?

Example --- I have A2:A10 with numbers, B2:B10 has the formula. I paste in new information from A2:A20, can B11:B20 auto populate the formula without having to manually paste the formula?

 

[Ezguy4u]

Let's get the ball rolling. Type numbers and a formula in Cells A1 to A5 and B1 to B5. Select cell A1 and go to Insert tab. From the Insert tab select Table. See if this works for you.

Book1
	A	B
1	Column1	Column2
2	1	1
3	2	2
4	3	3
5	4	4
6	5	5
7	6	6
8	7	7
9	8	8
Sheet1

Cell Formulas
Range	Formula
B2:B9	B2	=A2