Auto fill

Joeengr 

To fill cells in Excel with an increment of 10 instead of 1, you can use the AutoFill feature with a custom fill series. Here's how you can do it:

1. Type your starting value in a cell (e.g., A1).
2. In the cell below it (e.g., A2), enter the value 10 more than the starting value (A1 + 10). In this example, it's "=A1+10."
3. Select both cells (A1 and A2).
4. Move your cursor to the bottom right corner of the selected cells (you'll see a small square called the "fill handle").
5. Click and drag the fill handle down for as many cells as you need. Excel will automatically increment by 10 for each cell.

Release the mouse button, and Excel will fill the selected cells with values incremented by 10.

For example, if A1 had the value 10, and you drag the fill handle down, you'll get a sequence in cells A2, A3, A4, and so on, with increments of 10 (20, 30, 40, and so on).

This method allows you to easily create a series of values with a specified increment. The text was created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.