I have an extremely basic question, but I have never found the answer by searching the internet. I simply want to create a large column of zeros with Excel.

Sometimes I want to create a huge matrix of zeros (maybe 600 rows by 500 columns) and then replace a few zeros with 1's to create a model design matrix.

I have always started by creating a column of, for example, 10 zeros, copying and pasting those zeroes, then copying and pasting the resulting column of 20 zeros, etc., until I had the desired number of rows. Then I would copy and paste that column of zeros one at a time over and over until I had the desired number of columns.

This procedure is tedious and time-consuming and I know there must be an easier way.

Do you know of any other methods?