天气预报 > 其他 > EXCEL能用行筛选吗
EXCEL能用行筛选吗
更新时间: 2020-09-21 00:00:00  

1、先单击A1单元格,然后点击全选,再按下复制快捷键,复制当前工作表的内容。

2、先要选中A1单元格,再进行全选,否则下一步操作可能出现选区不对,而无法实现粘贴。

3、接着新建一个空白工作表sheet2,把光标定位在A1单元格,然后右击,在弹出的右键菜单里选“选择性粘贴”。

4、接着勾选“全选”和“转置”两项,然后单击确定按钮,即可将sheet1的内容粘贴。

关键词: excel 筛选

EXCEL能用行筛选吗相关经验

天气预报

最新推荐

页面:/news/view-2474364/ | 耗时:0.3910 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=2474364 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2474364 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2474364 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1112154,1089070,1119492,1060205,1093685,1041719,1091401,999216,1078679,1053066,1111500,1063475,1052687,1047027,1081408,1042088,1126819,1083425,1081015,1048760,1093697,1097771,1048406,1098781,1048394,1100667,1079281,1056336,1100643,1087813) ORDER BY field (ArticleID,1112154,1089070,1119492,1060205,1093685,1041719,1091401,999216,1078679,1053066,1111500,1063475,1052687,1047027,1081408,1042088,1126819,1083425,1081015,1048760,1093697,1097771,1048406,1098781,1048394,1100667,1079281,1056336,1100643,1087813)