how to number rows and columns automatically in Excel.

To add numbers automatically in excel.

1. Insert the first number

we have to insert the first number in our numbering column.文章源自LuckYou.ORG-https://luckyou.org/125.html

So I enter the number 1 here and press the enter key on our key board.文章源自LuckYou.ORG-https://luckyou.org/125.html

文章源自LuckYou.ORG-https://luckyou.org/125.html

2. drag the fill handle

Now I select this cell again.文章源自LuckYou.ORG-https://luckyou.org/125.html

and in the bottom right corner, you will see this little square which is called the fill handle.文章源自LuckYou.ORG-https://luckyou.org/125.html

文章源自LuckYou.ORG-https://luckyou.org/125.html

when we now press and hold the "ctrl" key on our keyboard (all the time), and drag this fill handle down.文章源自LuckYou.ORG-https://luckyou.org/125.html

you can see that we will get an automatic numbering in this column.文章源自LuckYou.ORG-https://luckyou.org/125.html

文章源自LuckYou.ORG-https://luckyou.org/125.html

So that’s it.文章源自LuckYou.ORG-https://luckyou.org/125.html