ExcelBanter - Repetitive Data in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Repetitive Data in Excel (https://www.excelbanter.com/excel-worksheet-functions/114632-repetitive-data-excel.html)

Exceldummy

Repetitive Data in Excel

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

RagDyeR

Repetitive Data in Excel

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?

All times are GMT +1. The time now is 02:29 PM.