原创 Excel表格怎么样设置输入重复项提醒？
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在Excel中，<span style="color: black;">倘若</span>制作大型数据录入表，<span style="color: black;">需求</span>表格内数据<span style="color: black;">不可</span>有重复项，<span style="color: black;">一般</span><span style="color: black;">状况</span>是<span style="color: black;">咱们</span>输入完成表格后，在逐一<span style="color: black;">检测</span>表格内<span style="color: black;">是不是</span>有重复项，<span style="color: black;">这般</span>每次制表完成就还需<span style="color: black;">检测</span>一遍，会比较繁琐，<span style="color: black;">那样</span>能<span style="color: black;">不可</span>在制表过程中就自动提醒有重复项呢？下面就给<span style="color: black;">大众</span>介绍一下设置<span style="color: black;">办法</span>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q5.itc.cn/q_70/images01/20240926/8a2043d3c96e494bbf767b8c31d21b3f.png" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">封面</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span><span style="color: black;">过程</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>一：<span style="color: black;">要求</span>格式设置</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、选中需要设置重复项提醒的行或列，<strong style="color: blue;">点击【<span style="color: black;">起始</span>】-【<span style="color: black;">要求</span>格式】-【<span style="color: black;">明显</span><span style="color: black;">表示</span>单元格规则】-【重复值】，</strong>打开“重复值”对话框。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q2.itc.cn/q_70/images01/20240926/b3f86d784dea495b980dd1492cca29b7.png" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图1</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、在“重复值”对话框中，【设置为】<span style="color: black;">能够</span><span style="color: black;">按照</span><span style="color: black;">自动</span>需要将重复项设置需要的填充样式，<span style="color: black;">而后</span>点击【确定】。则在单元格输入重复项，就会自动标记提醒。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q5.itc.cn/q_70/images01/20240926/69a60f2f95ce466abbf64db4e1e16c47.png" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图2</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q4.itc.cn/q_70/images01/20240926/d3432ff8a0ae4dc3ba86f9a95ec7222d.png" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图3</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>二：数据验证设置</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、选中需要设置重复项提醒的行或列，<strong style="color: blue;">点击【数据】-【数据验证】-【数据验证】</strong>，打开“数据验证”对话框。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">注：有些版本“数据验证”是用“数据有效性”代替</strong>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q8.itc.cn/q_70/images01/20240926/411bb8a28a3841ecb416ee564df9d326.png" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图4</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、在“数据验证”对话框中，点击【设置】，设置参数：</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">①<strong style="color: blue;">【<span style="color: black;">准许</span>】<span style="color: black;">选取</span>为：自定义；</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">②<strong style="color: blue;">【公式】输入：=countif(A:A,A1)=1</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Countif函数<span style="color: black;">指的是</span>统计满足某个<span style="color: black;">要求</span>的单元格的数量；【A:A】<span style="color: black;">指的是</span>要设置重复项提醒的行或列；【A1】<span style="color: black;">指的是</span>要设置重复项提醒的行或列的<span style="color: black;">第1</span>个单元格名<span style="color: black;">叫作</span>；【=1】<span style="color: black;">便是</span>指<span style="color: black;">保准</span><span style="color: black;">每一个</span>数据<span style="color: black;">显现</span>的次数<span style="color: black;">仅有</span>一次。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q4.itc.cn/q_70/images01/20240926/7722490cf7314b998a6582dcc932b33d.png" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图5</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3、再在弹出的“数据验证”对话框中，<strong style="color: blue;">点击【出错警告】，【样式】<span style="color: black;">选取</span>“停止”，【错误信息】输入：重复值</strong>（可<span style="color: black;">按照</span><span style="color: black;">自动</span>需要设置），<span style="color: black;">而后</span>点击【确定】，则输入重复项就会弹出提示框。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q6.itc.cn/q_70/images01/20240926/f89124106c2b4d68838b8d20ca02638b.png" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图6</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q6.itc.cn/q_70/images01/20240926/5408ae30c6b7464789e243d954bda952.png" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">图7</span><a style="color: black;"><span style="color: black;">返回<span style="color: black;">外链论坛： http://www.fok120.com</span>，查看<span style="color: black;">更加多</span></span></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">责任编辑：网友投稿</span></p>
大势所趋，用于讽刺一些制作目的就是为了跟风玩梗，博取眼球的作品。 楼主节操掉了，还不快捡起来！
页:
[1]