如何删除空白单元格?
<p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">使用</span>WPS Office打开表格,选中需要操作的区域。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">依次点击</span>“开始”--->“查找”--->“定位”</span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">。</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">或者快捷键</span>“Ctrl+G”打开定位功能,</span><span style="font-family: 微软雅黑; font-size: 16px;">选择“空值”后点击“定位”</span><span style="font-family: 微软雅黑; font-size: 16px;">。</span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">鼠标右键其中任意一个定位后的空值,选择</span>“删除”</span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">即可。</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"> </span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><img src="https://res1.wpsacdm.cache.wpscdn.cn/images/0b761e546f751d3c6d055db7c8767eb0.gif" title="如何删除空白单元格?.gif" alt="如何删除空白单元格?.gif"></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><br></span></p><p><br></p>
頁:
[1]