1. OCAU Merchandise now available! Check out our 20th Anniversary Mugs, Classic Logo Shirts and much more! Discussion here.
    Dismiss Notice

Google Sheets - fill many cells

Discussion in 'General Software' started by fnp, Jun 8, 2020.

  1. fnp

    fnp Member

    Joined:
    Apr 20, 2004
    Messages:
    989
    I need to fill values across a distance of 10,000 (yes, 10k) columns, BUT only every ten columns.

    So the spreadsheet will be 10,000 columns wide, and the cell values in row 1 will be column 0 = 0, column 10 = 10, column 20 = 20 and so forth. The intervening cells will be blank. Is there anyway to easily do this? The blank cells are the difficulty and my Google-fu has failed to come up with an answer. The following rows will be similar but with different (larger) numbers.
     
  2. OP
    OP
    fnp

    fnp Member

    Joined:
    Apr 20, 2004
    Messages:
    989
    Thread bump.

    Nobody has any idea? OCAU has failed me...
     
  3. waltermitty

    waltermitty Member

    Joined:
    Feb 19, 2016
    Messages:
    1,393
    Location:
    BRISBANE

Share This Page

Advertisement: