Enter say 25 in A1 and K1.

Select A1 to T1.

Click on the fill handle of the selection, and drag along Row1 as needed.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Exceldummy" wrote in message
...
Is there a formula so that I can have excel enter the same number every 10th
cell in a row?