Automatic numbering and ordinal filling in Excel

Source: Internet
Author: User

The most powerful feature of Excel is the ability to work with data, which relies on hundreds of Excel's internal functions, and more on Excel's powerful VBA, which makes it easier for people who need to process data without programming, and for simple digital processing, Just like the Excel AutoNumber feature he can get your Excel serial number automatically populated, I think if you want to enter some special data series such as project serial number, date sequence and so on one day, if you enter it, it will be too sorry for Excel, because Excel automatic numbering can solve your task easily. , he can quickly complete automatic serial number fill, how to let Excel serial number automatically fill it?

First enter the starting data in the first cell. Enter the second data in the next cell, select the two cells, point to the fill handle at the bottom right of the cell, drag the cell fill along the left side of the column you want to fill, and the dragged cells will automatically fill in the sequence defined within Excel. (The following figure is automatically arranged in even order)

If you can often use some of the regular data (such as Employee list, or class list), defined as a sequence, in order to automatically fill in the future, not once and for all!

Customize Excel AutoNumber to achieve an automatic fill of Excel ordinal numbers as follows:

Select the Options command on the Tools menu, and then select the Custom Series tab. Enter a new sequence in the input box, noting the comma separating the half-width symbols between the new sequence items (for example: Zhangxiao, Li Xiaoxi, Wang Xiao Five ...), click the Add button to save the input sequence so that exce L The sequence of automatic numbering is complete.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.