Google Sheets – AutoFill Large Number of Cells

google sheets

I have 10,000 rows in my Google Sheet and I want the following sequence to repeat (without using formula):

        A          B
1      Q_1        R_1
2      Q_2        R_2
3      Q_3        R_3
.      .          .
.      .          .
10000  Q_10000    R_10000

I went through THIS article, that suggests to select the 2 rows and drag the square at bottom-right, which is practically time consuming to drag it down to 10,000 rows.

How to do it without using formula?

Best Answer

  • Enter this formula in the first cell: =CONCATENATE("Q_",ROW())
  • Select the first cell again.
  • Type Ctrl+C to copy.
  • Click in the address box (at the upper left corner of the sheet) and type in the range (e.g. A1:A10000) followed by Enter. This will select the range to be filled.
  • Type Ctrl+V to paste formula into all selected cells and you're done.

Alternatively, if you have Excel, you may use Home > Fill > Series... menu to do this without using a formula.

img1
img2

Related Topic