打开一个【Excel表格】,将数量列按【升序】方式排列。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/18d8bc3eb13533fa75bd0e4fb8d3fd1f41345b4c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
选择C列,【菜单栏】—【数据】—【自动筛选】—【升序】。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9d82d158ccbf6c81723cb189ac3eb13533fa404c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
升序后表格的顺序混乱需要调整回来,选择菜单栏下【撤销】按钮,或者用快捷键【ctrl+E】撤回操作。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6d81800a19d8bc3e44039bab928ba61ea8d3454c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
在表格中【插入】辅助列A列命名为序号。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/810a19d8bc3eb135c5cc2adab61ea8d3fd1f444c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
再次选择C列【升序】排列。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bd3eb13533fa828b5e280082ed1f4134970a5a4c?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/cdbf6c81800a19d84808196423fa828ba61e464c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
升序后得到原来的表格内容,以上就是教给大家的【Excel表格筛选之后,怎么调整回原来的表格内容的方法】。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d058ccbf6c81800aeaee146fa13533fa828b474c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述