• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to generate numbers 0,1,2,3 in adjacent cells

vletm

Excel Ninja
Ufoo
Without any formulas ...
Write to left-top-corner number 0 and one cell right side 1 >> select those cells and pull from right bottom corner as far as You needs.
Write (if needs) to left-top-corner number 0 and one cell below 1 >> select those cells and pull from right bottom corner as far as You needs.
 

Ufoo

Member
Ufoo
Without any formulas ...
Write to left-top-corner number 0 and one cell right side 1 >> select those cells and pull from right bottom corner as far as You needs.
Write (if needs) to left-top-corner number 0 and one cell below 1 >> select those cells and pull from right bottom corner as far as You needs.
Thanks Ninja. ROW(A1)-1 works quite well. Your suggestion will help me when I do not need to include the numbers in a formula.
 
Top