How to use the Word sorting function in Excel

Source: Internet
Author: User
Tags sort

How to use text sorting in Excel. Sorting is a very basic function in Excel, but we generally use only English letters or numeric sorting, and Chinese characters can be sorted.


First, let's open a sample worksheet as an example.

Locate the Sort and filter shortcut buttons on the Start tab panel and select the range cells you want to sort.

When clicked, the Prompt box pops up because the area cell checked by this example has the associated data, so we should choose to extend the selection.

In the Pop-up Sort panel dialog box, we click the option button to sort the strokes in the sort option.

We can see that after clicking the OK sort, the column permutations are arranged in order of strokes. But the previous serial number has changed, and we need to revise it again.

Check a column serial number cell, continue to click the sorting function, this time we do not select the expansion area, click OK, you can modify the success.

The above is excel in the use of Word sorting function diagram, the operation is very simple, we have learned? hope to help everyone!

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.