2

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 :

enter image description here

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 ?

1 Answer 1

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."

2
  • Note: the SEQUENCE function works only with integers without decimal. support.google.com/docs/answer/9368244?hl=en 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
    Feb 28, 2023 at 15:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.