打开excel表格文件
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6609c93d70cf3bc7b8937193c100baa1cd112a39?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
选中需要排序的区域,这样选中是以第一列的数值进行排列
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c2fdfc039245d688e1910edbb4c27d1ed21b2439?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
把鼠标放到选中区域上面右击,选择排序,选择排序的方式,我这边选择升序
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3ac79f3df8dcd100900f445e628b4710b9122f39?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
这样表格就按第一列的数值进行重新排列
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/71cf3bc79f3df8dcf8ae33eedd11728b47102839?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
如果是用第二列或者后面的列数值排序,就直接选择这个一列的数值
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b812c8fcc3cec3fdcead1b0ac688d43f87942739?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
把鼠标放到选中区域上面右击,选择排序,选择排序的方式,我这边选择升序
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c83d70cf3bc79f3dd072584faaa1cd11728b2939?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
出现这个对话框,选择拓展区域,这样整个表格就会按这个排序一起变动,如果选择以当前区域排序,那就会只改变选中的这一列
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9e3df8dcd100baa1e6bffbc45710b912c8fc2e39?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
点排序,就按这个选中的单元格排序
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d000baa1cd11728b6abe305dd8fcc3cec3fd2c39?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述