-
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结束计算，再向下填充。
