天气预报 > 生活 > excel整行排序
excel整行排序
更新时间: 2021-01-30 13:09:43  

1、选择要排序的整行,点击“数据”,选择“排序”。

2、在排序界面,点击“选项”,勾选“按行排序”,点击“确定”。

3、设置关键字,以及排序方式。比如要按A列的升序排序。如果选了排序的有标题栏的,下面要选择有标题行。

4、点击“确定”后,即可按行进行排序。

关键词: excel 排序

excel整行排序相关经验

天气预报

最新推荐

页面:/news/view-1059313/ | 耗时:0.9965 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=1059313 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1059313 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1059313 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(3425108,3118932,517942,663460,1361144,3202995,3498360,3968710,396214,3084334,3895699,914748,946422,3521180,3454471,3408908,752094,4024228,929784,471525,418441,3246979,2909182,3469094,1039853,103736,615303,3363630,3499460,1725638) ORDER BY field (ArticleID,3425108,3118932,517942,663460,1361144,3202995,3498360,3968710,396214,3084334,3895699,914748,946422,3521180,3454471,3408908,752094,4024228,929784,471525,418441,3246979,2909182,3469094,1039853,103736,615303,3363630,3499460,1725638)