Unlimited Web Space

Enjoy Unlimited web hosting

Oct 26, 2011

How to Auto-Increment/Auto-decrement Numbers in Excel in any series

1. select the cell from which you want to start the series or where the incrementing should start

2. enter the number which you want to start the serien
3. select the cell by keeping the cursor at the right bottom of the rectangle (the cursor will become a plus sign)
4. hold the right button of the mouse and drag where you want to increment/decrement the number
5. as you leave the mouse, options will appear, chose series and fill the amount you want to increment or decrement as (1)-for incrementing by 1 and (-1) to decrement by 1.

No comments:

Post a Comment