How to fill range of cells with same value using formula?

Question

I use this :

={0,0,0,0;0,0,0,0;0,0,0,0}

and it fill the range (4 columns and 3 rows) like this :

Is there any formula so i can fill it automatically?

For example start at cell A1 and fill 100 rows and 100 column with value 0 ?

Erik Tyler · Accepted Answer · 2021-07-10 10:58:11Z

2

Yes:

=SEQUENCE(100,100,0,0)

This reads "Fill 100 rows and 100 columns with a sequence that starts at zero and increments by zero."

answered Jul 10, 2021 at 10:58

Erik Tyler

5,1232 gold badges8 silver badges11 bronze badges

Note: the SEQUENCE function works only with integers without decimal. support.google.com/docs/answer/9368244?hl=en
– Matěj Kříž
Commented Feb 28, 2023 at 9:31
1

That is not what the poster asked. And these days, most would recommend the newer function anyway, which can handle any input: =MAKEARRAY(15, 6, LAMBDA(x, y, 0)) 0r =MAKEARRAY(15, 6, LAMBDA(x, y, 2.16)) or =MAKEARRAY(15, 6, LAMBDA(x, y, "cat")) etc.
– Erik Tyler
Commented Feb 28, 2023 at 15:21

Add a comment |

1 Answer 1