1. 单栏排序：鼠标点击需要排序的那一列的任一储存格，然后点击image.png

      1.   wps<br />       ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22105762/1626765126664-fb72c4bb-7a49-43bf-b3cd-d3dc8b35c3be.png#align=left&display=inline&height=83&margin=%5Bobject%20Object%5D&name=image.png&originHeight=165&originWidth=1692&size=44714&status=done&style=none&width=846)
    • excel中文排序是按照比划的多少来排的image.png

    注意：在进行单列排序的时候只能选取一个框框，不然可能会造成资料错误

    1. 多栏排序：将选取框放在表中任一栏框，然后选择

    image.png
    选择第一层排序 

    1.  ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22105762/1626765712996-936fb1fd-90f8-409c-afa6-8c497f285b90.png#align=left&display=inline&height=299&margin=%5Bobject%20Object%5D&name=image.png&originHeight=598&originWidth=1344&size=354255&status=done&style=none&width=672)<br />     选择第二层排序<br />    ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22105762/1626765840342-73dca449-90a6-4ec6-9ff6-dbe6607ea800.png#align=left&display=inline&height=175&margin=%5Bobject%20Object%5D&name=image.png&originHeight=350&originWidth=1305&size=316948&status=done&style=none&width=652.5)<br />    最终结果<br />     ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22105762/1626765949599-d55a000e-6758-4f52-8a1a-2e8b7d691726.png#align=left&display=inline&height=484&margin=%5Bobject%20Object%5D&name=image.png&originHeight=968&originWidth=916&size=639320&status=done&style=none&width=458)
    1. 自订清单：excel可以使用为我们自己设定的顺序进行排列资料而不是根据内建的比划多少、数值大小来排列。

    将选框选在第一个框框内

    • 将商店一栏按照宅配-市场-杂货排序

    image.png
    image.png
    image.png