how to number rows and columns automatically in Excel.

admin ExcelComments876Read

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

how to number rows and columns automatically in Excel.文章源自LuckYou.ORG-https://luckyou.org/125.html

  1. 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

how to number rows and columns automatically in Excel.文章源自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

how to number rows and columns automatically in Excel.文章源自LuckYou.ORG-https://luckyou.org/125.html

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

 
匿名

Comment

Anonymous

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

Decide