Excel teaches you to quickly enter ordered text

Source: Internet
Author: User

If you often need to enter some regular sequence of text, such as numbers (1, 2 ...), date (1st, 2nd ...) , and so on, you can use the following method to implement its quick input:

1. First enter the first two elements of the text (such as "A, B") in the 1th or 22 cell where you want to enter the sequence text;

2. Select the two cells above and move the mouse over the lower right corner of cell 2nd into a fine crosshair (which we usually call the "fill handle"). Hold down the left mouse button and drag backward (or down) to the last cell that you want to fill in the sequence, and then release the left button, followed by the following elements of the sequence (such as "C, D, e ...") Automatically fill in the corresponding cells.

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: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.