47171; How to automatically insert a new row and retain functions/formulas from last row?

	A	B	C	D	E	F
1	=CONCAT()	NUMBER	ISTEXT()	NUMBER	=VALUE()	ISTEXT()

2	23	2	TRUE	3	23	FALSE
3	23	2	TRUE	3	23	FALSE
4	23	2	TRUE	3	23	FALSE
5	23	2	TRUE	3	23	FALSE
6	23	2	TRUE	3	23	FALSE
7	23	2	TRUE	3	23	FALSE
8	23	2	TRUE	3	23	FALSE
9	23	2	TRUE	3	23	FALSE
10	23	2	TRUE	3	23	FALSE
11	23	2	TRUE	3	23	FALSE
12	23	2	TRUE	3	23	FALSE
13	23	2	TRUE	3	23	FALSE
14	23	2	TRUE	3	23	FALSE
15	23	2	TRUE	3	23	FALSE
16	23	2	TRUE	3	23	FALSE
17	23	2	TRUE	3	23	FALSE
18	23	2	TRUE	3	23	FALSE
19	23	2	TRUE	3	23	FALSE
20	23	2	TRUE	3	23	FALSE