首页 / 教程

wps表格中按人名查找 | 在wps表格中快捷查找姓名

2022-12-30 23:58:00

1.怎样在wps表格中快捷查找姓名

1、打开电脑，然后进入到电脑桌面，打开要查寻人所在的excel表格，进入到表格中；

2、在主菜单栏 [开始]选项中找到 [编辑]界面，然后点击[编辑]界面，然后找到 [查找和选择]选项，点击[查找和选择]选项；

3、找到[查找和选择]选项，然后点击 [查找和选择]选项，在下拉的选项中点击 [查找]选项；

4、点击 [查找]，会弹出 [查找和替换]的工具框，在其中 [查找内容] 中输入想要找的人名，如李四，点击 [查找全部]，需要查找的人名就出来。

2.怎么在WPS表格中查找人名

本文以win7系统为例进行演示，具体步骤如下所示。

1、点击左上角的下拉按钮全选表格内容。

2、点击查找和选择对内容进行查找。

3、本文以李二狗为例，在查找框中输入李二狗点击查找全部。

4、会自动查找出人名所在的单元格坐标。

3.如何在WPS表格中查找多个人名

1、先把要筛选的人名列出来。

2、然后进入数据页面，点击高级筛选。

3、点击高级筛选后，列表区域就选择要筛选的区域，条件区域就选择要查找的人名区域，然后复制到中就随便选择一个单元格放置筛选出来的数据。

4、点击确定筛选后，就可以这几个人名的都查找出来了。

4.wps 或者excel 怎么用首字母查找姓名

假设源数据（姓名）在Sheet1的A列。

1、在Sheet1的B1输入

=LOOKUP(CODE(A1),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"})&IF(LEN(A1)>1,LOOKUP(CODE(MID(A1,2,1)),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}),"")&IF(LEN(A1)>2,LOOKUP(CODE(MID(A1,3,1)),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}),"")

回车并向下填充；

2、Sheet2的A1留给你输入姓名拼音开头（如LYH或LY）;

3、Sheet2的A2输入

=INDEX(Sheet1!A:A,SMALL(IF(ISNUMBER(FIND(A$1,Sheet1!B$1:B$1000)),ROW($A$1:$A$1000),4^8),ROW(1:1)))&""

数组公式，输入后先不要回车，按Ctrl+Shift+Enter结束计算，再向下填充。

wps表格中如何按人名查找