Excel Autofill

Occasional Visitor

Is there a way to auto-fill that only pull data from every tenth cell (B3, B13, B23.......B333 ect)?


2 Replies





You can do that using a formula like this:




If you put the formula in cell B1 and fill it down, the calculation will be applied only in every tenth cell!



Maybe you need this...


and then copy it down.

Related Conversations
Autofill Options not available
sailho in Excel on
3 Replies
Fill data from a barcode into a system
JKeyfayettevillear in PowerApps & Flow on
1 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies